topic Re: Can't run VBS scripts from within SAS in ODS and Base Reporting https://communities.sas.com/t5/ODS-and-Base-Reporting/Can-t-run-VBS-scripts-from-within-SAS/m-p/173334#M12406 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Mon, 06 Oct 2014 17:29:45 GMT art297 2014-10-06T17:29:45Z Can't run VBS scripts from within SAS https://communities.sas.com/t5/ODS-and-Base-Reporting/Can-t-run-VBS-scripts-from-within-SAS/m-p/173333#M12405 <HTML><HEAD></HEAD><BODY><P>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!</P></BODY></HTML> Mon, 06 Oct 2014 17:10:50 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Can-t-run-VBS-scripts-from-within-SAS/m-p/173333#M12405 PhilfromGermany 2014-10-06T17:10:50Z Re: Can't run VBS scripts from within SAS https://communities.sas.com/t5/ODS-and-Base-Reporting/Can-t-run-VBS-scripts-from-within-SAS/m-p/173334#M12406 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Mon, 06 Oct 2014 17:29:45 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Can-t-run-VBS-scripts-from-within-SAS/m-p/173334#M12406 art297 2014-10-06T17:29:45Z Re: Can't run VBS scripts from within SAS https://communities.sas.com/t5/ODS-and-Base-Reporting/Can-t-run-VBS-scripts-from-within-SAS/m-p/173335#M12407 <HTML><HEAD></HEAD><BODY><P>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.</P><P>BTW: I already allowed XCMD on the workspace server.</P></BODY></HTML> Tue, 07 Oct 2014 11:17:53 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Can-t-run-VBS-scripts-from-within-SAS/m-p/173335#M12407 PhilfromGermany 2014-10-07T11:17:53Z Re: Can't run VBS scripts from within SAS https://communities.sas.com/t5/ODS-and-Base-Reporting/Can-t-run-VBS-scripts-from-within-SAS/m-p/173336#M12408 <HTML><HEAD></HEAD><BODY><P>Phil: This may help: <A href="http://blogs.sas.com/content/sasdummy/2009/11/19/using-the-x-and-systask-commands-from-sas-enterprise-guide/" title="http://blogs.sas.com/content/sasdummy/2009/11/19/using-the-x-and-systask-commands-from-sas-enterprise-guide/"> Using the X and SYSTASK commands from SAS Enterprise Guide - The SAS Dummy</A></P></BODY></HTML> Tue, 07 Oct 2014 12:40:02 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Can-t-run-VBS-scripts-from-within-SAS/m-p/173336#M12408 art297 2014-10-07T12:40:02Z