Execute macro in a program

[Former Member]

How to execute a macro of excel from a report?

[Former Member]

How to execute a macro of excel from a report?

[Former Member]

using the FM SAP_CONVERT_TO_XLS_FORMAT.

to run the macro:

CREATE OBJECT h_excel 'EXCEL.APPLICATION'.

call method of h_excel 'WORKBOOKS' = h_mapl.

set property of h_excel 'VISIBLE' = 0.

call method of h_mapl 'OPEN'

EXPORTING

#1 = d_file.

CALL METHOD OF H_EXCEL 'ActiveWorkbook' = h_book .

CALL METHOD OF H_book 'Activesheet' = H_sheet .

CALL METHOD OF h_excel 'RUN'

EXPORTING

#1 = ld_macro.