VB Script Not Running

[msquared99]

I have some VB Script that I run through Scheduled Tasks that runs a macro.

The script was running fine until IT done some server maintainence.

Now the script only runs during the day when I am at work. Before it would run at 6:45AM before I got to work.

I just find it odd that the script will no longer run at 6:45 but it will run at any other time I am at my desk and schedule it to do so.

Any ideas or suggestions?

Thanks,

Mike

 

[crouchsw]

Can you upload the script?

 

[NARAYANK991]

Hi Mike ,

What are the configuration settings for this task in the Scheduled Tasks ? Is there a start time mentioned ?

Narayan

 

[msquared99]

Here is the script:

Option Explicit
Dim xlApp, xlBook
Set xlApp = CreateObject("Excel.Application")
'~~> Change Path here
Set xlBook = xlApp.Workbooks.Open("[URL='http://chandoo.org/forum/file:////abc1hb2/data/Phone']\\abc1hb2\data\Phone[/URL] Stats Macro V2.xls", 0, True)
xlApp.Run "PhoneStatsV2"
xlBook.Close
xlApp.Quit
Set xlBook = Nothing
Set xlApp = Nothing
 
WScript.Quit

The script will run as long as I am logged on to the system. It was running before IT done some sort of update. And yes I have the task scheduled to run at 6:45 M-F.

Thanks for your help.

 

[NARAYANK991]

Hi Mike ,

I may be wrong , but the script is totally independent of the time ; the problem you are talking about seems to do with certain restrictions / privileges associated with your login on the server.

The script may have the time still put on it , but if the required permissions / policies have changed due to the server maintenance , the proper person to check this with would be your IT manager.

Narayan

 

[msquared99]

Narayan,

Exactly! I found out that the time on the server and the time on my PC was off. They were not synced up.

IT ran a update and now all is fine.

Thanks everyone for your help!

Mike