topic Re: WORD & EXCEL in Application Development and Automation Discussions

WORD & EXCEL

Former Member — Tue, 07 Jun 2005 16:58:46 GMT

One abap report fills an excel file. This report open a word file (is a layout who extracts data from the previous excel file).

Our problem is that in the newer versions of word not extract the data of the excel and put into word file automatically.

Re: WORD & EXCEL

ssimsekler — Tue, 07 Jun 2005 17:16:48 GMT

Hi Jorge

I am not sure whether I can then help but nevertheless I think you should elaborate your requirement and make it more clear.

However, check the OLE commands that the report uses to extract data from MS Excel and puts into MS Word. Try this procedure independent from ABAP environment by recording a macro and then inspect the script code wheteher you need to change OLE call routines in the ABAP reports.

Regards

*--Serdar <a href="https://www.sdn.sap.com:443http://www.sdn.sap.comhttp://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.sdn.businesscard.sdnbusinesscard?u=qbk%2bsag%2bjiw%3d">[ BC ]</a>

Re: WORD & EXCEL

Former Member — Wed, 08 Jun 2005 07:25:06 GMT

First the abap report open an excel file .Then fills rows below the header.

At last open the word file ( the correspondence layout ).Automatically word should extract the data of excel and fills the layout of word.

Why in microsoft word 2000 sp2 do it automatically and not in microsoft word 2000 sp3