topic Execute macro in a program in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/execute-macro-in-a-program/m-p/4212414#M1006608 <HTML><HEAD></HEAD><BODY><P>How to execute a macro of excel from a report?</P></BODY></HTML> Wed, 16 Jul 2008 11:37:35 GMT Former Member 2008-07-16T11:37:35Z Execute macro in a program https://community.sap.com/t5/application-development-and-automation-discussions/execute-macro-in-a-program/m-p/4212414#M1006608 <HTML><HEAD></HEAD><BODY><P>How to execute a macro of excel from a report?</P></BODY></HTML> Wed, 16 Jul 2008 11:37:35 GMT https://community.sap.com/t5/application-development-and-automation-discussions/execute-macro-in-a-program/m-p/4212414#M1006608 Former Member 2008-07-16T11:37:35Z Re: Execute macro in a program https://community.sap.com/t5/application-development-and-automation-discussions/execute-macro-in-a-program/m-p/4212415#M1006609 <HTML><HEAD></HEAD><BODY><P>using the FM SAP_CONVERT_TO_XLS_FORMAT.</P><P>to run the macro:</P><P>CREATE OBJECT h_excel 'EXCEL.APPLICATION'.</P><P>call method of h_excel 'WORKBOOKS' = h_mapl.</P><P>set property of h_excel 'VISIBLE' = 0.</P><P>call method of h_mapl 'OPEN'</P><P>EXPORTING</P><P>#1 = d_file.</P><P>CALL METHOD OF H_EXCEL 'ActiveWorkbook' = h_book .</P><P>CALL METHOD OF H_book 'Activesheet' = H_sheet .</P><P></P><P>CALL METHOD OF h_excel 'RUN'</P><P>EXPORTING</P><P>#1 = ld_macro.</P></BODY></HTML> Wed, 16 Jul 2008 11:41:12 GMT https://community.sap.com/t5/application-development-and-automation-discussions/execute-macro-in-a-program/m-p/4212415#M1006609 Former Member 2008-07-16T11:41:12Z