Error ole_object_metnod_error from MS_EXCEL_OLE_STANDARD_DAT

[Former Member]

Hi all, Good Morning.

We have an abap program that uses the FM MS_EXCEL_OLE_STANDARD_DAT. The program displays a button 'to download into excel' and when clicked, the FM gets executed and an excel sheet opens up with the data. It has been working fine on the user pc's (Microsoft XP).

One user recently changed the pc, and it has Micorsoft Windows 7 (64 bit). Since then, clicking on the button is resulting in the error 'Ole_object_method_error'.

There is no change in the abap program.

Have any one you had this problem, and fixed it? If you have would you please share the solution?

Thank you for reading the post.

Good day.

[Former Member]

See note 721793 [Problems with MS_EXCEL_OLE_STANDARD_DAT|https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=721793].

Rob

[Former Member]

Hi Rob,

I have read the note 721793, and it makes perfect sense. We will have to use another FM.

Thank you and have a great day.

[Former Member]

I've used FM XXL_SIMPLE_API. It's pretty easy and does the trick.

Rob

[Former Member]

Dear Rob,

We have facing same problem for our internal program. This program working fine on some of system but not working properly on windows 7, GUI 730.

Could you please share your solution, so we can fix this issue?

Regards,

Ajay Asawa