View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
 
Posts: 2,452
Default Making several Excel Apps Visible

How about when you startup the Excel app keep hold of the objects in a
collection or array and go through that to make them all visible?
What is your code that starts the Excel apps?

RBS

"Ed White" wrote in message
...
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