topic Re: Launch a SAS program using VBA marco in SAS Programming

Launch a SAS program using VBA marco

marzouso — Mon, 20 Dec 2021 07:43:30 GMT

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 — Mon, 20 Dec 2021 08:04:09 GMT

Reeza — Mon, 20 Dec 2021 16:58:07 GMT

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 — Tue, 21 Dec 2021 23:57:22 GMT

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