Hi Guys, Please help me out ASAP. I was trying to run a vba subroutine by writing code in SAS. I followed no. of ways and took help from diffrent blogs as poted by no. of peoples on diffrent site. I saved and excel file including a macro function in .xlsm (book1) n tried to run this file using sas. code i wrote on sas : options xsync; data _null_; file excel; put  '[open("c:\book1.xlsm")]'; run; data _null_; file excel; put '[run("macro1")]'; run; but this didnt work. my sas code didn't give error, instead of this it got hanged out. Somehelp me out plz. so that i can run my code as much as possible and can represent to my client. note: my vba code has no. of subroutine,i tried on a smalll macro to try this but didnt get result. Waiting for reply. Thanks & Regards, Mohit ... View more