G
Guest
Hi All
I've run into an odd error message when closing a some Excel workbooks. It appears as though it's looking for a Auto_Close sub in an externally referenced XLA and it can't find that XLA file. However, I see no reference to that sub anywere in the VBA editor. The closest I've come is when I look at the file using Script Editor, or I export the file as an XML spreadsheet, I see a mysterious SupBook tag with a reference to the XLA. Is there any way for me to easily remove the SupBook reference via the Excel GUI or (even better) programmatically? It's a pain to have to go through Script Editor to remove the XML and synchronize it back with the original XLS for a large number of files
Thanks!
I've run into an odd error message when closing a some Excel workbooks. It appears as though it's looking for a Auto_Close sub in an externally referenced XLA and it can't find that XLA file. However, I see no reference to that sub anywere in the VBA editor. The closest I've come is when I look at the file using Script Editor, or I export the file as an XML spreadsheet, I see a mysterious SupBook tag with a reference to the XLA. Is there any way for me to easily remove the SupBook reference via the Excel GUI or (even better) programmatically? It's a pain to have to go through Script Editor to remove the XML and synchronize it back with the original XLS for a large number of files
Thanks!