07-16-2008 12:37 PM
07-16-2008 12:41 PM
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.