there is a syntax problem with the Save.as command In the archives, See http://groups.google.com/groups?q=dde+save.as+group:comp.soft-sys.sas&hl=en&lr=&ie=UTF-8&scoring=G&selm=4B3822B43D03D311A6050000F68ABFE7B77504%40dshsbudland.dshs.wa.gov&rnum=1

"David Schwartz" <david_schwarz@SRA.COM> wrote in message news:200307111455.h6BEtRF21411@listserv.cc.uga.edu... > I have been submitting the following: > > options noxwait noxsync symbolgen mtrace mlogic mprint msglevel=i; > x 'C:\Progra~1\Micros~1\Office10\excel.exe'; > > so that I can submit commands to Excel from within SAS as in the following: > > filename cmds dde 'EXCEL|SYSTEM'; > data _null_; > x = sleep(10); > run; > data _null_; > %let path=c:\report_&st..xls; > file cmds; > put "[Save.as(&path)]"; > put "[File.Close()]"; > put '[QUIT()]'; > run; > > The result is the following error: > > ERROR: Physical file does not exist, EXCEL|SYSTEM. > NOTE: The SAS System stopped processing this step because of errors. > NOTE: DATA statement used: > real time 0.00 seconds > cpu time 0.00 seconds > > I have checked, and the 'Ignore other applications' box in Excel is not > checked. Any other ideas on what the problem might be? > > DLS