topic Re: how to run VBA macro through SAS in SAS Programming

how to run VBA macro through SAS

ganeshsas764 — Wed, 24 Jan 2018 16:58:09 GMT

Hi Team,

Can you please advise me how to run the VBA Macro through SAS 9.4,

Thanks & regards

A Ganesh

Re: how to run VBA macro through SAS

PeterClemmensen — Wed, 24 Jan 2018 17:00:27 GMT

Check out the examples here

http://www.sascommunity.org/wiki/A_Poor/Rich_SAS_Users_Proc_Export

Re: how to run VBA macro through SAS

art297 — Wed, 24 Jan 2018 17:06:19 GMT

If @PeterClemmensen is right, and you are looking to run VB script from SAS, you can run it by using:

call system(yourVBscript.);

The updated version of the paper that @PeterClemmensen mentioned, which is a SAS macro that both creates and runs VB script, can be found at: http://www.sascommunity.org/wiki/Excelling_to_Another_Level_with_SAS

Art, CEO, AnalystFinder.com

Re: how to run VBA macro through SAS

ganeshsas764 — Wed, 24 Jan 2018 17:08:35 GMT

Thank you,

But I want only execute the VBA macro, no need to export any data to excel
file.

Re: how to run VBA macro through SAS

Reeza — Wed, 24 Jan 2018 17:15:46 GMT

DDE. Use google to find examples.

Re: how to run VBA macro through SAS

ganeshsas764 — Wed, 24 Jan 2018 17:20:14 GMT

Hi ,

I tried below-mentioned code but I am getting error,

options noxwait noxsync;
x '"C:\Program Files\Microsoft Office\Office\excel.exe" ';
/* Sleep for 5 seconds to give Excel time to come up */
data _null_;
x=sleep(5);
run;
filename cmds dde 'excel|system';
data _null_;
file cmds;
/* Open the excel file test.xlsm which contains the VBA macro */
put '[open("c:\temp\test.xlsm")]';
/* Run myVBAmacro */
put '[run("test.xlsm!myVBAmacro")]';
run;

Re: how to run VBA macro through SAS

ballardw — Wed, 24 Jan 2018 18:18:19 GMT

@ganeshsas764 wrote:

Hi ,

I tried below-mentioned code but I am getting error,

When you get errors it really helps to share the actual error. Best is to copy the code submitted with the error and other messages from log and paste into a code box opened using the forum {I} icon. The code box will preserve formatting of error messages.

Note that DDE may be interfered with by other programs that are running on your computer. I know that Cisco Jabber is one and that the process, not just the application window, have to be killed before DDE will work on my computer.