Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error when multiple macro driven workbooks open
We currently use several macro driven workbooks. The problem we have
recently encountered is that some users are experiencing fatal errors when having more than one of these workbooks open. For instance: I open WorkbookA.xls and enable macros, select a couple validations, run a query, look at my results. I then open WorkbookB.xls and do the same thing but now I get a fatal error or I go to close one of the workbooks and get the fatal error. Anyone have any idea as to what the problem may be? One of the errors I have seen is: Excel is encountering a problem and needs to close . . .. . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error trap on Workbooks.Open | Excel Programming | |||
macro or code to open multiple workbooks | Excel Discussion (Misc queries) | |||
Macro that will add data from multiple workbooks to the 1st open r | Excel Discussion (Misc queries) | |||
Excel 2003 Workbooks.Open with CorruptLoad=xlRepairFile fails on Excel 5.0/95 file due to Chart, with Error 1004 Method 'Open' of object 'Workbooks' failed | Excel Programming | |||
error on oXL.Workbooks.Open | Excel Programming |