Solved

About hidden instance of excel...

Posted on 2004-09-08
3
243 Views
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?

Thanks,
0
Comment
Question by:Mike Eghtebas
3 Comments
 
LVL 7

Accepted Solution

by:
wesbird earned 300 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
5.
0
 
LVL 33

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.

Regards,

Mike
0
 
LVL 2

Assisted Solution

by:pittbb
pittbb earned 200 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.
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
Article by: Martin
Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
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…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

743 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now