Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Handling Excel Apps?
Using VB.Net, and MS Excel 9.0 Object Library (2k)
My program runs Excel in the background to get a ton of information. By default I have: myExcelApp.Visible = False, but what I have trouble with is that if the user should open a spreadsheet outside of the program my current Excel Application becomes visible. What is worse is that if they should open and then close Excel while my program is executing my program dies with it. I did some extra error loops to make it load a new Excel if my current one should close but shouldnt there be a way to avoid this all together? To clarify. 1) User opens my program. (Excel gets some data in the background.) 2) Program waits for user input to move to next form/display. 3) User minimizes my program and then opens Excel. - Any of my open workbooks suddenly become visible here... 4) User finishes with Excel and closes it. 5) User maximizes my program and gives it some input to move to the next form. (Hence more Excel loading needed.) 6) My program crashes because Excel has been closed. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Handling Excel Apps?
myExcelApp.IgnoreRemoteRequests = True
will make your instance private. Be sure to set this property back to False, just before you kill off your myExcelApp object, otherwise all future instances of Excel will be affected. -----Original Message----- Using VB.Net, and MS Excel 9.0 Object Library (2k) My program runs Excel in the background to get a ton of information. By default I have: myExcelApp.Visible = False, but what I have trouble with is that if the user should open a spreadsheet outside of the program my current Excel Application becomes visible. What is worse is that if they should open and then close Excel while my program is executing my program dies with it. I did some extra error loops to make it load a new Excel if my current one should close but shouldnt there be a way to avoid this all together? To clarify. 1) User opens my program. (Excel gets some data in the background.) 2) Program waits for user input to move to next form/display. 3) User minimizes my program and then opens Excel. - Any of my open workbooks suddenly become visible here... 4) User finishes with Excel and closes it. 5) User maximizes my program and gives it some input to move to the next form. (Hence more Excel loading needed.) 6) My program crashes because Excel has been closed. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2010 to be able to embed like Google Apps? | Excel Worksheet Functions | |||
Help - Alt-E hotkey does not work in MSOffice apps, no prob in other apps | Excel Discussion (Misc queries) | |||
Very slow using SaveAs in Excel (and other Office apps) | Excel Discussion (Misc queries) | |||
Excel closes all open apps when i close one | Excel Discussion (Misc queries) | |||
Switching to other apps while running macros in excel 97 | Excel Programming |