About hidden instance of excel...

Posted on 2004-09-08
Medium Priority
Last Modified: 2010-05-02
1. How many visible instance of excel could be loaded simultaneously?  
2. How many hidden instance of excel could be loaded simultaneously?
3. Can you think of situation where a hidden instance of an excel file might interfere with normal operation of excel files by user?
4. What problems could be expected if a file left open hidden?  (one case I can think of is that if a user opens it manually, not knowing it is already open, it will open as read-only).
5. How we can close all hidden instances of excel file upon closing a form?

Question by:Mike Eghtebas

Accepted Solution

wesbird earned 900 total points
ID: 12009625
??   1. I think... that as long as window handles are still available it should continue to load new instances subject to the internal limits in Windows itself (I know that if I'm running more than about 50-80 visible apps on my 2000 box that anything fails to open properly).

??   2. I expect... it depends on virtual memory limits of the PC itself before it destabilises.

3. If VBscript on a hidden instance locks up at 100% CPU in a loop it is dificult to control any instance of Excel

4. ... thinking
LVL 34

Author Comment

by:Mike Eghtebas
ID: 12009821
Re:> Questions 1 & 2.

I tend to agree with you on that.  Also I thingk there might be a limit of 250 or something like that.  These question are included only to set the stage for questions 3, 4 and 5.

I will hardly have more than 5 excel open and will have 1 hidden (unless could fails and leaves few hidden open).
I hope we could get some more feedbacks.



Assisted Solution

pittbb earned 600 total points
ID: 12010573
If it is left open, you won't be able to delete the file either.  It would also take up memory.  I would recommend that you make an effort to close them all when you're finished with them.

For 5, you can check the .visible property if you only want to close the hidden instances.

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

597 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question