Dear Sas folks, I try to export a large table (40k records comparable to sashelp.snacks) to an existing .xlsm file (microsoft excel macro file). But i dont's succeed 😞 Does anyone have the golden tip? i tried an failed with the following methods: 1) use proc export with dbms=xlsx. SAS creates a xlsx file even if the outfile is defined als xlsm. 2) use proc export with dbms=xlsm i get the message errror: DBMS type XLSM not valid for export. 3) assign a libname with the pc engine to the macro file and use ods excel and proc print 4) assign a libname with the pc engine to the macro file and use a range in the xlsm file. then use proc copy. success with small files, no succes with large files. 5) assign a libname with the pc engine to the macro file and then use a data stap i use sas EG 6.1. and SAS version 9.4. Kind regards, Unito
... View more