Hi ,   I tried below-mentioned code but I am getting error,   options noxwait noxsync; x '"C:\Program Files\Microsoft Office\Office\excel.exe" '; /* Sleep for 5 seconds to give Excel time to come up */ data _null_; x=sleep(5); run; filename cmds dde 'excel|system'; data _null_; file cmds; /* Open the excel file test.xlsm which contains the VBA macro */ put '[open("c:\temp\test.xlsm")]'; /* Run myVBAmacro */ put '[run("test.xlsm!myVBAmacro")]'; run;   ... View more

Thank you, But I want only execute the VBA macro, no need to export any data to excel file. ... View more

super ,  Thank you  ... View more

tq ##- Please type your reply above this line. Simple formatting, no attachments. -## ... View more

that values are stored in sas dataset,how to subset particular date values ##- Please type your reply above this line. Simple formatting, no attachments. -## ... View more

hi , this is ganesh, i have one doubt ,   id     name    date 101  xxx      19/05/15 102 YYY      19/06/16 103 zzz       19/05/15   i want '19/05/15' date values only  into output dataset ,how to solve this probleam .   Regards A.Ganesh ... View more

some X-ayhave different files,but i am impoerting only today file to create create sas dataset ... View more

yes , ##- Please type your reply above this line. Simple formatting, no attachments. -## ... View more