Calling An VB Macro in Excel Sheet from ABAP

[Former Member]

Hi,

In our Project implementation there is a need of Formatting the Excel Shhet and displaying the Output. I know that OLE can do it. But OLE is taking a lot of time.

Someone came up with an idea where we can record a macro in Excel and then call the macro in someway from our program.

Can anybody elaborate on the way how we can Call this Excel macro. I really dont know how we can implement this.

Do anybody worked on these lines.And guide me.

Thanks in Advance,

Arunava

[Former Member]

FUNCTION rh_start_excel_with_data allows you to download an internal table into a spreadsheet and fire a macro.

Please reward points accordingly.

[Former Member]

Hi John,

It was really helpful.It solved one of my needs of opening the file in Excel in frontend.

But could not get much how we can add the Macro Firing Capability. Where do I store this Macro Recorded and how to pass it.

Please guide with this Macro capability.

Thanks and Regards,

Arunava