No response on excel

I have added the wait for 10 seconds command, the excel is fully loaded, in the foregroud and get the input focus. The command "objXL.Cells(1,1).Value = 5 " can be executed. But excel is not responding when running command "objXL.Cells(1,2).Value = "=BLP|H!'AMP AU Equity,[PX_BID],ST=20080117 END=20080117PT=1 QT=P'".

Is BLP by any chance a Bloomberg API Excel Add-in? If yes, you can have a job calling Bloomberg API directly, bypassing Excel all together. In other words, you can make a VBScript job in 24x7 talking to Bloomberg and getting data directly using its COM/ActiveX interface.

Also, if it's a Bloomberg Add-in, please make sure you run the job in a directory where the Add-in can find the required license files or whatever other file dependencies it may need to find for a normal run. Maybe when you run the script or job it is looking for licenses files in 24x7 scheduler directory (because that's where the job is run) and hanging there if it cannot find the required files. To check this theory, try scheduling a run of the external VBS script you made recently for testing and which works when you run it manually. My guess, you saved that script in a directory from where it can run. It would be also interesting to try copying the same script into 24x7 directory and running it from there.

Please let us know how it goes.