Button Actions - Sequential Firing

Mon, 12 Nov 2012 20:29:04 GMT

If I set up two actions on a button, is there a way I can stop the second action from firing until the first action is complete?

The scenario I am working with is I have the first action actually opening a URL which will open an Excel file which is loaded into my QV app. I then have a second action which inititates a re-load. What I want to be able to do is add records to the Excel file, which will then be reloaded in the reload. It appears when I do this the reload fires immediately and does not wait until I have added records to, saved, and closed the Excel file.

Thanks,

Chris

Re: Button Actions - Sequential Firing

Mon, 12 Nov 2012 21:41:18 GMT

Have you thought about using a macro to handle the reload portion? For example, your button would load the document as it already does, then as a second action, run the macro:

Sub Load()

x=MsgBox("Click Ok to initiate reload",1,"Reload Document")

if x=1 Then
ActiveDocument.Reload

Else
Exit Sub
End If

End Sub

After the user saves his or her changes and clicks 'Ok', the document will reload. If the user clicks 'Cancel' the reload will not occur.

topic Re: Button Actions - Sequential Firing in QlikView

Button Actions - Sequential Firing

Re: Button Actions - Sequential Firing