Solved

About hidden instance of excel...

Posted on 2004-09-08
3
250 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 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.

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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

856 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