Accessing Windows registry / invoking macro

[wolfgang]

Hi!

I would like to access a certain entry in the windows registry out of an OpenOffice Basic macro.
Does anyone know how to do this??

And a second question:
I found out how to activate an instance of openOffice and open a certain OpenOffice Calc file out of my VisualBasic application. I know would like to invoke a macro in the Calc-file out of the VisualBasic application!
-Has anyone come across this requirement before and knows a solution??

Any help would be highly appreciated!

Thanks in advance!

wolfgang

[DannyB]

[Henrik]

Hi,

[Guest]

Hello!

Thank you very much for for the links to these topics of interest.

Unfortunately I still have some problems, invoking a macro stored in a certain workbook.

Out of my Visual Basic 6 application I open the OpenOffice calc document by:
Set objDocument = objDesktop.loadComponentFromURL("file:///c:/Test/DemoCode.sxc", "_blank", 0, args)
Set Frame = objDocument.getCurrentController().getFrame()

Then I want to call a macro in this document (DemoCode.sxc) and pass a parameter. According to the posts I read on this topic this should work somehow like:
Call dispatcher.executeDispatch(Frame, "macro://DemoCode/Standard.Module1.Hello(myText)", "", 0, args)

Unfortunately the macro is not executed.
Calling the macro works, if I place the macro not in the opened document, but in the "root" for macros (soffice) and then call it like:
Call dispatcher.executeDispatch(Frame, "macro:///Standard.Module1.Hello(MyText)", "", 0, args)

Has anyone an idea what I am doing wrong?

Thanks in advance,
wolfgang

[wolfo]

[DannyB]

Here is a related discussion with a very interesting proposed solution.

http://www.oooforum.org/forum/viewtopic.php?t=6768
_________________
Want to make OOo Drawings like the colored flower design to the left?