topic Re: use DDE save excel file and give the file a name in SAS Procedures

use DDE save excel file and give the file a name

Mike_Davis — Tue, 31 Jul 2012 20:18:33 GMT

Hello everyone,

When I use DDE to create and save an excel file,the default name is book1 and location is c:\My Document.

Could anyone telll me how to change the name and change the location?

Thanks

Mike

filename cmds dde 'excel|system';

data _null_;
   file cmds;
   put '[SELECT("R1C1:R20C3")]';
   put '[SORT(1,"R1C1",1)]';
   put '[SAVE()]'; /* This will save the new excel file to an excel file named "book1.xls",I want the saved file 's name is myfile.xls*/
   put '[QUIT()]';
run;

Re: use DDE save excel file and give the file a name

art297 — Tue, 31 Jul 2012 20:25:31 GMT

Have you tried changing your put save statement to something like?:

put '[save.as ("c:\OtherFolder\DifferentFileName.xls")]';

Re: use DDE save excel file and give the file a name

Mike_Davis — Wed, 01 Aug 2012 13:11:39 GMT

Thank you Art!

I tried "save as" didn't work,but as your advice use "save.as" will works !