Can we import excel vba marco into sas viya.... Can someone help?? I have a situation where in use

[Ajay09]

Can we import excel vba marco into sas viya.... Can someone help?? I have a situation where in user have four input files and one vba marco generate master in 5 sheets in an excel work book... Wants us to automate in sas..

[Sajid01 · Accepted solution]

It is not possible to import vba macro to run in SAS Viya.
However if the macro can be written into vb script and if SAS  Viya is being run on a Windows Machine, then the macro can be executed from SAS.
A better way would be to import the files into SAS and then export them into a singe workbook.

[Ajay09]

How do we run the vba marco code through sas??

[Sajid01]

Using X commands or systask (https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/hostwin/n1vt3ybuz7d0n1n0z1orjvq2ww3x.htm ,

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/hostwin/p09xs5cudl2lfin17t5aqvpcxkuz.htm )
An example is given at https://support.sas.com/kb/43/addl/fusion_43496_4_convert.sas.txt  and shown below

x "cscript ""your.vbs""";