Adding script in script editor using Excel VBA script

Fri, 16 May 2014 10:38:49 GMT

Hi all,

I am trying to create a Excel VBA Script which it will create a new QlikView document, adding script in script editor, reload and save. I am able to do new QlikView documet, reload and save but not able to add script in script editor. Providing sample code below.

Would someone be able to help me with my coding without using "SendKeys" method in Excel please?

Code:

Sub QV_App()

Dim QV_Path As String

Dim QV_App As Object

Dim QV_Doc As Object

Set QV_App = New QlikView.Application

Set QV_Doc = QV_App.CreateDoc

QV_Path = ThisWorkbook.Path & "\"

QV_Doc.SaveAs (QV_Path & "New.qvw")

QV_Doc.DialogEditScript

QV_Doc.DoReload

QV_Doc.Save

QV_Doc.CloseDoc

QV_App.Quit

End Sub

Regards,

Sai

topic Adding script in script editor using Excel VBA script in QlikView

Adding script in script editor using Excel VBA script