07-31-2012 04:18 PM
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?
filename cmds dde 'excel|system';
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*/
07-31-2012 04:25 PM
Have you tried changing your put save statement to something like?:
put '[save.as ("c:\OtherFolder\DifferentFileName.xls")]';