Button press triggers script to load first when macro is first action

[#1]

Hi,

I currently have a button on one of my Qlikview that has 2 actions: 1) run macro (just a msgbox to say that the load takes 8 minutes) then 2) reload the data.

Each time I click the button the script loads before I can see msgbox, which only displays after the 8 minute load is complete. is there a way to prevent the load until after the msg box "OK" button has been clicked?

thank you

[settu_periasamy · Accepted solution]

try to add the sleep time in the macro. And instead of reload action (assume 2nd action), you can add the same into macro itself. If you click 'Ok' then reload, else exit.

[#3]

I've tried sleep times in the past but couldnt get them to work. could you please provide the syntax. perhaps I was doing something wrong.

this is what I have:

sub  Wait

    ActiveDocument.getapplication.WaitForIdle

    ActiveDocument.getapplication.Sleep (1000)

End sub

[settu_periasamy]

Your code is seems to be fine. Have you tried reload into the macro instead of 2nd action?

[settu_periasamy]

Refer the below link for Message code.

Is there a way to may the Popup on a macro so that it is always on top?‌

if click ok, then write a code,

ActiveDocument.Reload

[#6]

this works. thank you. for partial reloads, is there a way to hide the loader screen when reloading?

[settu_periasamy]

Hi Erik,

May be check this link Hide Script Execution Progress Window

i didn't test. so i'm not sure about it.