Launch a SAS program using VBA marco

[marzouso]

Hi all,

I want to launch my SAS program (SAS Guide) using VBA.

I have a button in Excel page. This button is associated to a VBA program and i want that this vba program call a SAS guide program.

So that the user avoid to launch two programs (vba and SAS).

Thank you for your help.

[ChrisNZ]

Use call shell()

[Reeza]

First figure out how to call it from a prompt/shell command. Once you have that figured out, you can use the SHELL() command in VBA. 

[SASKiwi]

This Community article should help: https://communities.sas.com/t5/SAS-Communities-Library/Doing-More-with-SAS-Enterprise-Guide-Automati...

Please note that requirements change depending on your version of EG.