Adding script in script editor using Excel VBA script

[#1]

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