Executing Excel Session in Background

[Former Member]

All,

In SAP BW 3.5 we created a recording (through transaction SHDB) of accessing transaction UPSPL (is a SAP transaction with an Excel session embedded in it, data in the excel is written to the SAP database). Then generated an ABAP report of the recording. When running the ABAP report through se38 in the background, the excel mentioned above is not called/executed correctly i.e. the macros in the excel are not executed (probably because simulating running Excel macros in background is technically not possible?).

When running the ABAP report in the foreground (setting 'call transaction'), the report perfectly executes the macro i.e. result is the same as accessing and saving the excel manually through UPSPL.

Read somewhere that installing Excel on SAP (BW) server could be an idea? Because in the above the Excel desktop version is called?

Would you know how to solve the above? Or experiences with it? Thanks.

Regards, Meindert Postma

PS also posted the above on the SAP BW/BPS forum, from a more BPS point of view.

[TMNielsen]

Hi Meinder Postma

I don't know exactly how this works but I think it is like this:

The embedded excel functionality is obtained via SAPgui objects.

The application communicate with excel via a program-to-program-to-program interface between a program in the SAP kernel on the application server, via a SAPgui object on the PC with SAPgui installed and to excel on the same PC.

Like this:

Server SAP kernel <=> PC SAPgui <=> PC excel

In this setup I see no possible way that this can run in background, because in background you have no SAPgui communication at all.

best regards

Thomas