I'm using code supplied by JEC in this post which creates a "DAO.DBEngine.120" connection to an Excel workbook that can not be opened or it will crash the application. I am not at all familiar with data connections, and have no idea what I might be able to see in this closed file through this connection nor how to see it.
I'm wondering if, once I have the Sheet object through DAO, is there any way to see if that worksheet contains a particular named range? Or perhaps: I did use the zip file method on the "stubborn" file, and I can see an XML sheet that lists all the named ranges. Is it possible to access this XML list?
I'm wondering if, once I have the Sheet object through DAO, is there any way to see if that worksheet contains a particular named range? Or perhaps: I did use the zip file method on the "stubborn" file, and I can see an XML sheet that lists all the named ranges. Is it possible to access this XML list?