LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 05:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"