Hi Reeza, Thank for quick response, I used proc export and here is sample program Proc EXPORT DATA=sashelp.shoes OUTFILE= "\\SAS\UserData\newxlsm.xlsm" DBMS=EXCELCS REPLACE; PORT=9621; SERVER= 'T01LPS2021.ent.rt.com'; sheet="xlsm"; RUN; See the below error: 1. if I give DBMS=xlsx ERROR is: ERROR 180-322: Statement is not valid or it is used out of proper order. If I am giving DBMS=EXCELCS Error message is ERROR: CLI error trying to establish connection: [Microsoft][ODBC Excel Driver] Cannot update. Database or object is read-only. ERROR: Error in the LIBNAME statement.
... View more