Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following code and I think that works fine... However everytime that I open the Qlikview application the "Edit Module" windows appears spoiling the dashboard presentation (I've a loading page which appears for a few seconds)
SUB Reload
ActiveDocument.ReloadEx 0, 1
ActiveDocument.Sheets("SH1").Activate
END SUB
SUB Run_VBS
Set WshShell = CreateObject("WScript.Shell")
'WshShell.Run """" & chr(34) &
ActiveDocument.WshShell.Run chr(34) & "path\Scheduling.bat" & Chr(34), 0
Set WshShell = Nothing
END SUB
Sub RunThisOneInstead
Reload()
Run_VBS()
End Sub
Does anyone know how to fix this issue?
Thanks! ![]()
If you comment out this code, does the edit module still appear when you open the app?
If not, the code likely is the culprit.
It sounds like maybe you are running this macro as a document OnOpen trigger?
-Rob