topic OLE error during upgrade in Application Development and Automation Discussions

OLE error during upgrade

Former Member — Tue, 24 May 2011 15:18:05 GMT

Hello,

Our SAP system is upgraded from 4.6C to ECC6.0. OLE output in word is coming perfectly in 4.6C but not in ECC6.0. we get the word file in ECC6.0 but the table formats are missing. How should we handle this?.

Thanks.

Re: OLE error during upgrade

Sandra_Rossi — Tue, 24 May 2011 19:56:14 GMT

Hi Jk,

you didn't give enough details. OLE is on the frontend side so I don't understand why a SAP upgrade would make it fail. Did you check SAP notes?

Sandra

Re: OLE error during upgrade

Former Member — Thu, 26 May 2011 15:33:28 GMT

Hi Sandra,

OLE is in the front end side, but we are not getting the correct output . I was not able to get any OSS notes too. Even in 4.6C we get the proper word output with table structure in WindowsXP but when the same is executed in Windows7 we get the word output but the table macros are not executed correctly. The same happens in ECC6.0. Is it the problem with SOLE application or Windows application or Microsoft Word? Please guide with some solution..

Regards,

Re: OLE error during upgrade

Sandra_Rossi — Thu, 26 May 2011 17:37:15 GMT

Hi Jk,

So it's clear the issue is from the OLE commands, which seem to be not compatible with Word. Which version of Word is it in XP and 7?

You can debug the CALL METHOD, SET PROPERTY, etc., to see which one returns an error, i.e. SY-SUBRC is different from zero (note: sy-subrc can be tested only if there is not NO FLUSH in the OLE statements). There is also an OLE trace that you can activate on the SAPGUI (Alt+F12, Options, Trace, Automation).

Sandra

Re: OLE error during upgrade

Former Member — Fri, 27 May 2011 09:45:00 GMT

Hi Sandra,

In both WindowsXP and Windows 7, we are using Word 2007.

The below call methods return sy-subrc as 2.

CALL METHOD OF wordobj 'FontSize'

CALL METHOD OF wordobj 'InsertPara'.

CALL METHOD OF wordobj 'ToolsMacro'

CALL METHOD OF wordobj 'NextCell'.

Re: OLE error during upgrade

Sandra_Rossi — Fri, 27 May 2011 11:51:13 GMT

Hi Jk,

So these methods do not work for "wordobj", how is it instantiated?

Sandra

Re: OLE error during upgrade

Former Member — Fri, 27 May 2011 12:34:04 GMT

Hi Sandra,

OLE application WORD.BASIC is used.

CREATE OBJECT wordobj 'WORD.BASIC' .

Re: OLE error during upgrade

Sandra_Rossi — Fri, 27 May 2011 12:48:09 GMT

I don't understand how it can work on any Word version, "fontsize" is not a method of Word application! I think you should record a Word macro to simulate what you want to achieve, and compare the generated VBA code with what is in your program.