Programmatically obtaining info on Excel DLL's
Is there a procedure one could use to programmatically print out all DLL's that an Excel workbook refers to?
I know in MS Access, you can iterate the "References" and list the properties GUID, FilePath, BuiltIn, Name, etc.
Is there an equivalent in Excel?
If you have all the required DLL's listed in a column on a spare sheet, is there a way to 1) disconnect all DLL's , 2) read from the column some info (such as a name, filepath, or GUID) and re-link them?
--- Tom
__________________
--- Tom
|