use DDE save excel file and give the file a name

[Mike_Davis]

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;

[art297]

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

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

[Mike_Davis]

Thank you Art!

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