Exporting macro along with data - BEx web

[Former Member]

Hi,

I have to send BEx web data along with a macro. The purpose is every report user down loads in his desktop gets an unique macro along with the data. The user can later use that macro for further analysis of the downloaded data.

I was reading through the How to Use Web Printing with Microsoft Excel document which details about various objects such as Packages and ABAP classes. The ABAP class ZCL_RSR_XLS_ITEM_TEMPLATE contains methods such as SET_ITEM,RENDER_DATA,LOAD_TEMPLATE_FROM_DB,GET_TEMPLATE...etc. My question is whether these class and mehtods can it be enhanced to include a macro ???

Any suggestions is eagerly awaited,

Regs

D Bret

[Former Member]

Hi,

If you are planning to format the Excel cells with Macro You can run the Macro from the web page using Javascript.

Thank you

Arun

[Former Member]

Hi Arun,

How do you access / write excel macros using jave scripts ? can please send me an example ? In the mean time let me explain you my requirement again...

My end users are not happy with Web printing so they have decided to go with exporting web report an excel sheet. But once the data been collected in excel sheet many of the users wld like to have some mechanism to strip that exported excel data into multiple sheets. so that is the reason its been decided to send the generic macro to end users who exports the BEx report to an excel sheet and process it....

thanking you in advance,

D Bret