10-06-2014 01:10 PM
Hi guys, I am trying to use an x command to open/run a vbs script. The command is simply: options noxsync noxwait; x "F:\SAS_USER\myname\SAS2script\ext_files\VBS_TEST.vbs"; The VBS script is supposed to move data from a csv file to an excel work book and then run a macro. You can tell that it partially works, because an Excel process is started in the background. However, this excel process doesn't doesn't run any macros. When I run the very same command using command prompt, everything works fine. Has anyone ever experienced anything like this (script working in command prompt but not in SAS)? Thanks!
10-06-2014 01:29 PM
Phil: Since you indicate that it will run correctly from the command prompt, I can think of one alternative that would be easy to test, namely putting the command (to run the vb script) in a .bat file and using the x command to run the .bat file.
10-07-2014 07:17 AM
Thanks for your response, Arthur. I tried running the batch file with the command to run the vbs script, but it still isn't working. Then I tried the same thing in SAS Base (I walys use Enterprise Guide) and it worked. I was able to run both, batch file and vbs script directly via X command using SAS Base. So it looks as if something is blocking x commands in Enterprise Guide.
BTW: I already allowed XCMD on the workspace server.