Macro problem

Mon, 22 Jun 2009 17:24:11 GMT

I have problem with macro. I want to open OpenOffice sheet, but my macro don't work. When I push the button, then opens my macro code in black.

Macro code:

Sub prooviks
Dim oSM
Dim oDesk
Dim oDoc
Dim aNoArgs()

Set oSM = CreateObject("com.sun.star.ServiceManager")
Set oDesk=oSM.createInstance("com.sun.star.frame.Desktop")
Set oDoc = oDesk.loadComponentFromURL("private:factory/scalc", "_blank", 0, aNoArgs)

End Sub

OpenOffice Basic will work with code like this:

Sub proov
Dim oSM
Dim oDesk, oDoc as Object
Dim aNoArgs()

Set oDesk=createUNOService("com.sun.star.frame.Desktop")
Set oDoc=oDesk.loadComponentFromURL("private:factory/scalc","_blank",0,aNoArgs())

End Sub

Can somebody help me, I'm new in QlikView and in OpenOffice too. Thanks!

Macro problem

rwunderlich — Tue, 23 Jun 2009 01:28:54 GMT

You will have to allow System Access for this macro. It's required for the CreateObject() call.

To allow system access, change the "Requested Module Security" and "Current Local Security" in the lower left corner of the macro editor window.

-Rob

Macro problem

Thu, 25 Jun 2009 12:19:54 GMT

Thanks! ´Its working now!

topic Macro problem in QlikView

Macro problem

Macro problem

Macro problem