How to call a SAS macro from VBA

[deleted_user]

Hi,
Can anybody please tell me how to call (or run) a SAS macro with parameters, from VBA.

My macro is something like this

%para2sas(response=,indvars=,strata=);

I have created listboxes to get user inputs from VBA ,but the problem is to connect them with the SAS macro.

Thank you in advance..

[deleted_user]

hi,

call SAS in batch mode with SYSPARM System Option

M.

[deleted_user]

Thank you very much M.
Bye