Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel cores when trying to close a workbook after exporting+removing VBA modules
I have a utility class in an 'addin' that listens for onClose and Save
events on worksheets. If a flag is set when the sheet is closed all the modules are exported to a repository and then the file is saved with no modules loaded. However this removing of modules followed by a call to close the spreadsheet core's excel in the VBA. This is probably due to VBA still having hooks into functions that have now been removed. Is there anyway to refresh VBA's view of what is loaded and what is not? I have tried inserting onTime events to fire the close of the worksheet momentarily after it is exported, but this still causes problems. Is there anyway to find the cause of these numerous core's? Or does anyone know a way to update the internal caches of VBA as to what is loaded and what is not? Many Thanks Tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exporting code modules | Excel Programming | |||
Removing modules via VBA | Excel Programming | |||
Work-around for exporting sheet contents and removing code | Excel Programming | |||
Removing VB Modules Automatically | Excel Programming | |||
Removing the 'X' (close) from forms in excel VB | Excel Programming |