how to run vba code using sas studio?

[blueskyxyz]

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....

[AhmedAl_Attar]

@blueskyxyz 

There are two issues here:

1. 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
2. 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