topic Re: Qlikview Desktop - "Edit Module" is always appearing in QlikView

Qlikview Desktop - "Edit Module" is always appearing

Mon, 04 Jan 2016 18:45:12 GMT

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!

Re: Qlikview Desktop - "Edit Module" is always appearing

m_woolf — Mon, 04 Jan 2016 19:56:02 GMT

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.

Re: Qlikview Desktop - "Edit Module" is always appearing

rwunderlich — Tue, 05 Jan 2016 00:09:32 GMT

It sounds like maybe you are running this macro as a document OnOpen trigger?

-Rob