topic Excel Office Integration, problem using program twice in same computer in Application Development and Automation Discussions

Excel Office Integration, problem using program twice in same computer

Former Member — Mon, 23 Nov 2009 12:18:35 GMT

Hello everybody,

I have a problem in a program which generate Excel sheet via ABAP.

I retrieve data in SAP and I sent it in Excel application via different class of Excel Office Integration ( I_OI_LINK_SERVER etc.. )

This is my problem :

- Launch transaction with data A

- Display Excel with some SAP data

- Open an other mode SAP

- Launch the same transaction with Data B

- PROBLEM : Display Excel with data A

Thx you for your responses...

Re: Excel Office Integration, problem using program twice in same computer

Former Member — Tue, 09 Feb 2010 22:23:39 GMT

Hi Guillaume,

We have had the same problem with Report Writer reports and Office Integration.

I found the following notes:

- 159499 u2013 look at point 13

- 176642

They basically say that this can not be done due to OLE2.0.

We found the following link:

http://blog.drewery.net/2006/08/29/utilising-dual-monitors-with-microsoft-excel-2003/

They are talking about opening multiple Excel windows (or processes in task manager). This works if we run Excel by itself but it does not work if we open Excel via OLE (ie SAP Report Writer).

Jerry