Discussion Board for collaboration on QlikView Scripting.
Someone help me with VB script that can open a Qlikview Document and save it and close it without any alert message. I m trying to create -prj folder using vb macro.
pth = "C:\Users\macka\Desktop\gyhijk.qvw"
Set qvdoc = application.OpenDocEx(pth, 1, 0)
Set oFSO = CreateObject("Scripting.FileSystemObject")
oFSO.CreateFolder Left(pth, Len(pth) - 4) & "-prj"
set oFSO = nothing
you should be able to find out how to get a value into a macro elsewhere on the site so i won't go into that
I use these loop-routine for various export- and print-jobs and it should work for your task, too.
dim doc, obj, iRow, app, path, newApp, newdoc
set doc = ActiveDocument
set obj = doc.GetSheetObject("TB01") 'tablebox with apps and full-paths
for iRow = 1 to obj.GetRowCount - 1
set app = obj.GetCell(iRow, 0) 'application
set path = obj.GetCell(iRow, 1) 'path
set newApp = ActiveDocument.GetApplication
set newdoc = newApp.OpenDoc (path.Text & "\" & app.Text,"","")
set obj = nothing
set app = nothing
set path = nothing
set newApp = nothing
set newdoc = nothing