Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is it possible to write a sub that would make visible (Excel.Visible=True)
various instances of Excel applications that are currently running invisible? I'm debugging a VB program that opens a new Excel application and keeps it invisible (Excel.Visible-False) while processing data, and then closes it (Excel.Quit). As I am debugging it, I often interrupt the program (because of exceptions, etc.) before it quits Excel, and I subsequently find in the Task Manager numerous Excel applications running, but they are all invisible, so I can't look at them or close them easily. I know you can access one Excel app using GetObject(,"Excel.Application"), but is there a way to loop through all of the Excel apps running to make each of them visible? I can see how many are running using Diagnostics.Process.GetProcessesByName, but I can't figure out how to make all of them visible. -- Ed |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Making Drop Down Box Visible with Excel 2003 | Excel Discussion (Misc queries) | |||
Help - Alt-E hotkey does not work in MSOffice apps, no prob in other apps | Excel Discussion (Misc queries) | |||
Making a form visible | Excel Discussion (Misc queries) | |||
making only specified columns visible | Excel Discussion (Misc queries) | |||
making a group visible (or not...) | Excel Programming |