Supbook
 

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!

Supbook
 

Nevermind - I figured out that there was a hidden "name" under activeworkbook.names called "Auto_Close" that had the reference, so I deleted that "name" and all is okay.