Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
brindlogcool
Creator III
Creator III

Binary Statement through vbscript

I am trying to create the QlikView Document and add the binary statement using the vbs script. I am able to create the Document and open the Edit script using the below vb script 

Set objFSO = CreateObject("Scripting.FileSystemObject")

set qv = CreateObject("QlikTech.QlikView")

Set docObj = qv.CreateDoc

docObj.DialogEditScript

But not finding the way to add the Binary Statement and the Load script. Any suggestions to include the Binary statement and Load script in the above macro

14 Replies
marcus_sommer

ActiveDocument.GetApplication.Quit ???

brindlogcool
Creator III
Creator III
Author

Thanks Marcus. i tried it is not working.

marcus_sommer

It didn't work because you calls a dialog:

docObj.DialogEditScript

which couldn't be closed by macro-statement (I don't know one unless shortcuts which are NOT recommended) but you don't need these statement then read, change and set the properties from the document is enough.

- Marcus

brindlogcool
Creator III
Creator III
Author

Thanks for your response Marcus.

I agree with your comments. I am fine with save and close the QlikView document. I don't need to close the DialogEditScript. But the problem is when the DialogEditScript is open i am not able to close or Quit the application.

If we are able to close the QlikView Document when the DialogEditScript is open then the problem is resolved.

marcus_sommer

Make:

REM docObj.DialogEditScript

and try it again.

- Marcus