Solved

About hidden instance of excel...

Posted on 2004-09-08
3
252 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Introduction I needed to skip over some file processing within a For...Next loop in some old production code and wished that VB (classic) had a statement that would drop down to the end of the current iteration, bypassing the statements that were c…
Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
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…
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…

734 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