04-26-2016 03:54 PM - edited 04-26-2016 04:18 PM
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 */
/* Close DDE SYSTEM COM Channel */
Need further help from the community? Please ask a new question.