I am trying to run a /vbs script as a Scheduled task on a Windows Server.
For Testing I have just got the following in the script.
on error resume next
msgbox "Before Starting Excel"
Set xlApp = Nothing
Set xlApp = GetObject(,"Excel.Application")
if xlApp is Nothing then
Set xlApp = CreateObject("Excel.Application")
msgbox "Excel should be running - (Check in the task manager Processes tab)"
xlApp.visible = False
xlApp.visible = true
If I run the script from a short cut on my local machine it runs fine.
If I manualy run it as a scheduled task from my local machine it runs fine.
From my local machine it runs as a scheduled task fine.
If I login to the Server and manualy run the script from a short cut it runs fine.
If I try to run it manualy from the task scheduler on the server nothing happens.
From the Server nothing happens when it is set to run as a scheduled task.