Running a macro with COM

[Roalf]

Hallo,

i want to run a OO-Macro from a external Programm (LotusScript, similar to VBA). And i use the COM-Interface.

i Try with:
set dispatcher = createObject("com.sun.star.frame.DispatchHelper")
call dispatcher.executeDispatch(document, ".uno:RunMacro", "macroname", 0, Array())

but this doesn't work.

It's something wrong or exisis another way to run a macro?


Roalf

[B Marcelly]

Hi,
From the thread Using COM for OOo with different languages I have found threads
Lotus Notes Lotusscript and OpenOffice... (OLE Stuff)
OLE Classes in Open Office
Hope this helps.

[Roalf]

Hello Berndard,
thanx for your Help, but i now the base technic about the COM UNO bridge as well. I've written some well running code to automate OO from Lotus. But now i have a particular problem. I have to start a macro und i don't now how in have to do this with the COM UNO bridge. (in OO-Basic its a simple "call macro").
If have try to found this in the OO-documentation but, these documentation overextended me a little bit in this case.

Roalf

[B Marcelly]

Hi,

i now the base technic about the COM UNO bridge as well. I've written some well running code to automate OO from Lotus.

It did not sound like that from your code.
You may download the VBx OOo tool for VBA and read the documents. You will find routines for calling macros. Do the equivalent in your language.
If your program loads a document containing macros, you have to load it with the option MacroExecutionMode set to a correct value.

It is preferable in my opinion to avoid calling a macro if you can do the equivalent through COM.