I need to create from Qlikview VBScript an Excel document containing a button, and I need to associate a VB macro to the button

Thu, 31 May 2012 08:52:48 GMT

Hi,

I need to create from Qlikview VBScript an Excel document containing a button,

and I need to associate a VB macro to the button. Here below the script I created.

function CreateSheet()

.....

Set XLApp = CreateObject("Excel.Application")

XLApp.Visible = true

set XLDoc = XLApp.Workbooks.Add

XLDoc.Worksheets(1).Buttons.Add(50, 50, 50, 50).Select

XLDoc.Worksheets(1).Buttons(1).Name = "btnPippo"

'XLDoc.Worksheets(1).Buttons("btnPippo").Caption = "Pippo"

XLDoc.Worksheets(1).Buttons("btnPippo").OnAction="pippo"

.......

end function

function pippo()

msgbox "ciao"

end function

I'm able to create the button, but I got an error ( ) when I try to associate the "OnAction" method.

Does anyone has experienced such a problem?

thank you very much

topic I need to create from Qlikview VBScript an Excel document containing a button, and I need to associate a VB macro to the button in QlikView