topic Msgbox autoclose (macro) in QlikView

Msgbox autoclose (macro)

Thu, 16 Feb 2017 02:19:29 GMT

Hi All,

I tried this script but it's not autoclosing the msgbox. Any idea how?

function Test1()

Set WshShell = CreateObject("WScript.Shell")

BtnCode = WshShell.Popup("export",1)

End function

Thanks,

Lyn

Re: Msgbox autoclose (macro)

petter — Thu, 16 Feb 2017 03:00:42 GMT

Autoclosing will never work due to a bug that Microsoft don't want to fix in WshShell ... it has nothing to do with QlikView and will never be fixed. It has been complained about for probably much more than 10 years already...

Re: Msgbox autoclose (macro)

petter — Thu, 16 Feb 2017 03:07:00 GMT

Actually there is a more indirect way of getting it to work anyway by launching mshta.exe:

Then the timeout will work as expected.

Sub ShowExportStart
  CreateObject("WScript.Shell").Run "mshta.exe vbscript:close(CreateObject(""WScript.Shell"").Popup(""Test"",2,""Real%20Time%20Status%20Message""))"
End Sub

Re: Msgbox autoclose (macro)

Anil_Babu_Samineni — Thu, 16 Feb 2017 03:34:47 GMT

You are written Java script. Can you check how Scripting Engine looks like. It should Javascript

Re: Msgbox autoclose (macro)

Thu, 16 Feb 2017 03:58:28 GMT

amazing! this one works! Thank you!