Try the following code, a few slight modifications that could be the issue, ie you can say open instead of file-open and the close statement doesn't need a path if its the only file you're working with. options noxwait noxsync; x ' "C:\Program Files\Microsoft Office\OFFICE11\EXCEL.exe" '; data _null_; x=sleep(5); run; filename ddecmd dde 'excel|system'; data _null_; file ddecmd; put '[OPEN("C:\My Projects\Temp\Data Capture\CreateCSVFiles.xls")]'; run; data _null_; file ddecmd; put '[CLOSE()]'; put '[QUIT()]'; run;
... View more