topic Saving an XLSX template as an XLSX using SAS in SAS Programming

Saving an XLSX template as an XLSX using SAS

Doug____ — Tue, 26 Apr 2016 20:18:20 GMT

What I need to do is the following:

1) open an XLSX workbook template with SAS (no problem)

2) save the same XLSX file under another name as an XLSX using sas (can only get it to do XLS).

I have two macros and the first one works fine to open the template. Saving it as an XLSX is a bit of an issue. I am using Version 9.2 TS2M3.

filename cmds dde "EXCEL|SYSTEM";

/* Save current workbook using new name */

data _null_;

file cmds;

put '[error(false)]';

put "[save.as(%bquote("&_xlsfile"

,&_type_num

))]";

run;

/* Close DDE SYSTEM COM Channel */

filename cmds;

Reeza — Tue, 26 Apr 2016 20:39:47 GMT

What version of Excel are you using?

What happens if you do a Save.as with just first parameter, the filename?

put "[save.as(%bquote("&_xlsfile"))]";

Doug____ — Wed, 27 Apr 2016 18:41:23 GMT

I was able to locate some information stating that type = 51 is xlsx. This seems to work fine also.

ballardw — Wed, 27 Apr 2016 18:53:11 GMT

Yet another reason to avoid DDE if at all possible. That value of 51 could well be different in the next release of Office.