Re: Determining whether Excel is running

From: Bill Murphy (wmurphy_at_houston.rr.com)
Date: 11/29/04 

Date: Mon, 29 Nov 2004 02:09:10 GMT

Eric,

I believe you have answered my question. There was an Excel.exe process
running, even though no task was visible in Task Manager or on my task bar.
This could have resulted from an abnormal end to my program, which is still
in the testing mode. Is there a way in VBA to detect this hidden process
and kill it?

Bill

"Eric Schittlipz" <eric@schittlipz.com> wrote in message
news:codu79$72v$1@sparta.btinternet.com...
> "Bill Murphy" <wmurphy@houston.rr.com> wrote in message
> news:lKpqd.47698$KQ2.9267@fe2.texas.rr.com...
> > Doug,
> >
> > This function returns true when I run it from the immediate window for
> > both
> > Word and Excel, although I can see from my task bar and from Task
Manager
> > that neither of them is running. Could there be something else in my
> > Windows 2000 configuration that is confusing the issue for this function
> > and
> > for the IsExcelRunning function below?
> >
> > Bill
>
> In your Task Manager did you also check out the processes tab? If you are
> running code like you posted, you could easily start a hidden instance of
> Excel but not notice it in the Task Manager. Try setting the .visible
> property of the application object to true like this:
>
> Set xlApp = GetObject(, "Excel.Application")
> If Err.Number=0 Then
> IsExcelRunning=True
> xlApp.Visible=True
> End If
> Set xlApp = Nothing
>
> In general though, you should use some form of error handling to ensure
your
> code does not inadvertently leave a hidden instance running which you
> created and have left abandoned.
>
>
>

Relevant Pages

  • Re: Determining whether Excel is running
    ... If there's an instance running, ... >> In your Task Manager did you also check out the processes tab? ... >> running code like you posted, you could easily start a hidden instance of ... >> code does not inadvertently leave a hidden instance running which you ...
    (microsoft.public.access.modulesdaovba)
  • Re: Two Files infected-Cant find them!
    ... Right click on your task bar and select task manager - click the ... processes tab. ... run a full virus scan in safe mode. ...
    (microsoft.public.security.virus)
  • Re: Computer Slows - Busy Processor
    ... >>Right click on the task bar at the bottom and then click task manager and then ... I now see what is taking CPU processing time. ... >adaware at least once every two days now. ...
    (microsoft.public.windowsxp.basics)
  • Re: Windows XP taskbar freezes-unresponsive
    ... the task bar becomes responsive again. ... But then after a while the task manager becomes unresponsive again. ... In Vista apparently there is something called GDI object leak ... The time you've taken to try and fix XP is more than it would have taken to reinstall XP, the only sure way to know you're malware free. ...
    (microsoft.public.windowsxp.general)
  • Re: Run minimized
    ... It is not on the task bar or in the application list. ... (Another ZOOM re-minimizes it, thus the flashing.) ... You cannot also find the main vfp screen in the task manager because ...
    (microsoft.public.fox.programmer.exchange)
Loading