topic Execute Excel macros from ABAP in Application Development and Automation Discussions

Execute Excel macros from ABAP

Former Member — Sun, 08 Sep 2013 11:21:19 GMT

Hi,

I've used OLE to export data from SAP to Excel, so I have the document, and at last I'd like to execute a Excel macro from ABAP inside this new Excel that I've just created, is it possible? Where should I store the Excel macro?.

I've read about I_OI_DOCUMENT_PROXY interface, but I can't execute the macro yet.

Please, if somebody knows how to do it, it would be great.

Thanks.

Re: Execute Excel macros from ABAP

Former Member — Mon, 09 Sep 2013 11:32:23 GMT

Hi Mario,

CREATE OBJECT go_excel 'EXCEL.APPLICATION' .

SET PROPERTY OF go_excel 'Visible' = 1 .

GET PROPERTY OF go_excel 'Workbooks' = gs_wbooks .

GET PROPERTY OF go_wbooks 'Application' = go_app .

CALL METHOD OF go_app 'Run'

EXPORTING #1 = macro_string .

Regards

Re: Execute Excel macros from ABAP

Former Member — Tue, 10 Sep 2013 19:31:45 GMT

Hi Mohammed,

I've tried, but I don't know where store the Excel macro to be executed from SAP (C:\Windows\System32??), and which name and extension. I'd need some real example.

Re: Execute Excel macros from ABAP

Former Member — Thu, 12 Sep 2013 05:48:24 GMT

Hi Mario,

The Macros you want to execute are and should be part of global excel template.

It is not in any system32 folder.....

To execute anything you need to connect to it... so

You need to create and EXCEL OLE Object.

Open the WorkBook and then Execute the Macro.

the macro_string is the name of the Macro you want to execute.

Regards

Re: Execute Excel macros from ABAP

Former Member — Thu, 12 Sep 2013 06:10:54 GMT

Hi Mario,

I have never executed an Excel Macro.
But found this sample report SAPRDEMOEXCELINTEGRATION.
It calls MACRO 'R3StartupMacro' at line number 288.

In OAOR & SBDSV1 Transaction codes, you will need to give

CLASS NAME = SOFFICEINTEGRATION and CLASS TYPE = OT to see associated details.

Regards,
Nisha Vengal.

Re: Execute Excel macros from ABAP

Former Member — Thu, 12 Sep 2013 06:43:58 GMT

Hi Mario,

Check reply by Lars on thread http://scn.sap.com/thread/148656

Appends Source Code Internal table
Sub functionname()
...
End Sub
Then calls method passing source code internal table. Gets a script name OKADIS
Call method pptr_script_collection->add_script_from_table
Runs EXECUTE_MACRO using that script name OKADIS

Check original post by Rebecca on thread http://scn.sap.com/thread/26946

DATA: macro_string(50) TYPE c VALUE 'FB03process.FromTheBeginning'

Short MACRO as "EXCELNAME.FromTheBeginning" is directly written in EXECUTE_MACRO method.

Regards,

Nisha Vengal.