topic Re: Can we import excel vba marco into sas viya.... Can someone help?? I have a situation where in in SAS Programming

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

Ajay09 — Sat, 10 Sep 2022 15:29:50 GMT

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

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

Sajid01 — Sat, 10 Sep 2022 19:27:28 GMT

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.

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

Ajay09 — Sat, 10 Sep 2022 19:54:38 GMT

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

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

Sajid01 — Sat, 10 Sep 2022 21:31:52 GMT

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""";