topic Re: Problem with i_oi_document_proxy->execute_macro in Application Development and Automation Discussions

Problem with i_oi_document_proxy->execute_macro

Former Member — Tue, 16 Aug 2016 03:40:13 GMT

Hi experts.

I 'm using class document_proxy for export some table to Excel.

But I can't execute macro using method document_proxy->execute_macro( ).

Text macro is:

Sub test ()

Range("A5:E28").select

End Sub

The message is: TYPE MISMATCH: 'Range'.

Maybe somebody faced such problem and can help me to solve it?

Re: Problem with i_oi_document_proxy->execute_macro

Sandra_Rossi — Tue, 16 Aug 2016 08:00:37 GMT

did you try:

set x = excel.activeworkbook

x.range("A5:E28").select

Re: Problem with i_oi_document_proxy->execute_macro

Sandra_Rossi — Tue, 16 Aug 2016 08:02:30 GMT

did you separate macro lines with CR_LF ?

did you try with the simplest call : msgbox("hello world") ?

Re: Problem with i_oi_document_proxy->execute_macro

Former Member — Tue, 16 Aug 2016 09:50:02 GMT

Hello, Rossi.

Thanks for help. Yes I separate micro lines with CR_LF.

I will try first variant and I got an error 'Object required: excel'.

Re: Problem with i_oi_document_proxy->execute_macro

Sandra_Rossi — Tue, 16 Aug 2016 14:21:12 GMT

did you try with the simplest call : msgbox("hello world") ?

Re: Problem with i_oi_document_proxy->execute_macro

Former Member — Wed, 17 Aug 2016 01:21:33 GMT

Simplest call msgbox("hello world") is work. But if I use excel objects such as Excel, Worksheet, Range the execute_macro( ) do not understand it.

Re: Problem with i_oi_document_proxy->execute_macro

Sandra_Rossi — Wed, 17 Aug 2016 13:19:58 GMT

I did a test, and we need to add Set excel = GetObject(,"Excel.Application"), then excel.range("A5:E28").select should work

Re: Problem with i_oi_document_proxy->execute_macro

Former Member — Thu, 18 Aug 2016 04:26:12 GMT

Thanks very much, it is work.

But I thought that execute_marco( ) execute VBA macro, but it turns out that is VBscript macro.

Re: Problem with i_oi_document_proxy->execute_macro

Sandra_Rossi — Thu, 18 Aug 2016 06:17:01 GMT

Yes, with DOI, you may only select VBscript or javascript.

Re: Problem with i_oi_document_proxy->execute_macro

Former Member — Thu, 18 Aug 2016 07:07:31 GMT

Thanks Sandra very much. I am understand.

Re: Problem with i_oi_document_proxy->execute_macro

Former Member — Fri, 19 Aug 2016 04:06:47 GMT

I 've got one more question. We have implemented the editor for entering Vbscript text and we need syntax check entering text. It is possible to implement it in SAP.

Re: Problem with i_oi_document_proxy->execute_macro

Sandra_Rossi — Fri, 19 Aug 2016 13:46:43 GMT

No idea (maybe write it to a local .vbs file, and call cl_gui_frontend_services=>execute). I always do it that way: first, record the VBA macro (manual actions recorded automatically), adjust it to make it work according to your requirements, then copy it to a VBS file run it and edit it until it works (there are few rules to know to convert a VBA into a VBS).

Re: Problem with i_oi_document_proxy->execute_macro

Former Member — Mon, 22 Aug 2016 02:32:57 GMT

Hello, Sandra.

Thanks for the idea.

Re: Problem with i_oi_document_proxy->execute_macro

Former Member — Thu, 25 Aug 2016 04:44:02 GMT

In continuation of the issue.

When we use execute_macro, we write in marco text such as ws.Range("A3").Value = "Сережа", that is we want write Russian text in cell, but when the macro runs in Excel cell we see abracadabra(jubberwocky). It seems what problem with encoding, but we could not find parameter Encoding in execute marco or in add_marco.

Maybe somebody knows where we can specify the encoding?