Trouble With Vb Script

[KReidy]

Could somebody please help me, I am trying to run the attached script without much success!!! I have inserted admin tracelog throughout the script but I am not receiving any of these in the log file (also attached)

 

I have tested another script to see if the tracelog was set up properly and it is. The script retrieves a number from an excell spreadsheet , returns it to the script via a variable that plays a message.

 

I hope someone will point me in the right direction.

VoiceGuideScript.txt

VoiceGuideLogFile.txt

[SupportTeam]

You have a call using xlApp before xlApp is created. Try removing this line:

 

xlApp.DisplayAlerts = False

 

To test VB scripts just save them in the .vbs file and try running them by double clicking on the file, you will then see any error messages.

 

 

 

Dim xlApp, xlBook, xlSht

Dim filename, value1, value2

filename = "c:\Test\Test1\test.xls"

 

 

Set vg = CreateObject("vgServices.CommandLink")

xlApp.DisplayAlerts = False

vg.Admin_TraceLogAdd 0, 0, "**** calling CreateObject Excel.Application"

Set xlApp = CreateObject("Excel.Application")

 

...

[KReidy]

Thank you very much I did as you said and it is working now.