Hello,
I have a macro below to store the load script of each QlikView file. This is to help with traceability of data, as well as keeping some level of version-control/documentation of our load scripts (it's not easy to store QlikView apps within Git due to file sizes and running in QMC changes binaries so using something like GitHub desktop, it's never easy to see what's been updated and what hasn't. And creating -prj folder exports messes with production dashboards.)
This macro works, however, I will need to go into several hundred QlikView apps, paste the macro, allow system access for macros, and add the trigger to run the macro. Is there any way to automate this process? Or is there any easier way to execute what I'm trying to accomplish?
And a second question, we are running Qlikview 2017 SR3 v12.20.20400.0 - I only have four options for document triggers. Is there any way to add additional triggers (e.g. "OnSave"?)
Sub ExportLoadScript
file = ActiveDocument.Evaluate("vFilepath")&ActiveDocument.Evaluate("vFilename")&".txt"
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFile = objFSO.OpenTextFile(file, 2,True)
objFile.Write(ActiveDocument.GetProperties.Script)
objFile.Close()
End Sub
