Run a .vbs Script as a Scheduled task on Windows Server 2008 R2
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.
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.