Problem with i_oi_document_proxy->execute_macro

[Former Member]

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?

[Sandra_Rossi]

did you try:

set x = excel.activeworkbook

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

[Sandra_Rossi]

did you separate macro lines with CR_LF ?

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

[Former Member]

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'.

[Sandra_Rossi]

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

[Former Member]

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.

[Sandra_Rossi]

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

[Former Member]

Thanks very much, it is work.

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

[Sandra_Rossi]

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

[Former Member]

Thanks Sandra very much. I am understand.

[Former Member]

  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.

[Sandra_Rossi]

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).

[Former Member]

Hello, Sandra.

Thanks for the idea.

[Former Member]

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?