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 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
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Error trap on Workbooks.Open Barb Reinhardt Excel Programming 1 July 20th 06 02:09 PM
macro or code to open multiple workbooks Duane Reynolds Excel Discussion (Misc queries) 1 March 14th 06 08:18 AM
Macro that will add data from multiple workbooks to the 1st open r jbsand1001 Excel Discussion (Misc queries) 0 April 23rd 05 07:52 PM
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 Frank Jones Excel Programming 2 June 15th 04 03:21 AM
error on oXL.Workbooks.Open arieribbens Excel Programming 3 April 26th 04 10:09 AM


All times are GMT +1. The time now is 03:58 AM.

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

About Us

"It's about Microsoft Excel"