LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 34
Default Making several Excel Apps Visible

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Making Drop Down Box Visible with Excel 2003 it''''''''sh hardy Excel Discussion (Misc queries) 2 August 9th 09 07:41 PM
Help - Alt-E hotkey does not work in MSOffice apps, no prob in other apps Bob Newheart Excel Discussion (Misc queries) 4 July 28th 08 03:57 PM
Making a form visible [email protected] Excel Discussion (Misc queries) 3 March 11th 07 02:28 PM
making only specified columns visible [email protected] Excel Discussion (Misc queries) 1 April 6th 05 04:57 PM
making a group visible (or not...) Mark J Kubicki Excel Programming 0 August 27th 04 03:24 AM


All times are GMT +1. The time now is 09:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"