topic how to run vba code using sas studio? in SAS Programming

how to run vba code using sas studio?

blueskyxyz — Sat, 29 Apr 2023 15:06:28 GMT

hi guys,

Do anyone have some experience to run vba code using sas studio(https://welcome.oda.sas.com) instead of PC SAS?

Thanks so much.


FILENAME myfile '/home/.../VB/test.xlsm';

x 'start excel';
x 'cd "/home/.../VB/test.xlsm"';
x 'excel /e myfile';
x 'application.run "test"';
x 'quit';

https://support.sas.com/resources/papers/proceedings16/7120-2016.pdf#:~:text=SAS%20programmers%20can%20employ%20PUT%20statements%20within%20a,run%20a%20VBA%20macro%20in%20an%20Office%20application.

Re: how to run vba code using sas studio?

AhmedAl_Attar — Sat, 29 Apr 2023 15:47:53 GMT

@blueskyxyz

There are two issues here:

The SAS ODS is running on Linux Operating System, while VBA is a Windows technology! So unless you find a technology/interface that can run Windows programs on Linux/Unix operating systems, you are out of luck
If you ever manage to find a resolution for Issue #1, SAS ODA doesn't allow users to run OS commands. It's a security measure. Which means you'll not be able to run any commands from a command Prompt! 😐

Hope this helps