WSH start and check applications...

[I2007]

Hi...

I tried to search the forum for this answer and I couldn't find anything solving my issue.

Is it possible via whs to check if a particular program i.e excel is started and that the worksheet loaded is book1.xls?

And if not open excel with book1.xls and wait till it's loaded before the script contiues...???

This has been killing me for a while...

Thanks in advance...

i2007

 

[PHV]

Have a look at the GetObject function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[mrmovie]

Set objApp = GetObject(, "Outlook.Application") '#### Find existing instance of Outlook
If Err Then
WScript.Quit() '#### If Outlook isn't running, quit the script
'Set objApp = CreateObject("Outlook.Application") '#### uncomment this & comment out above line to get data even if Outlook isnt running
End If