Button - actions in sequence - one after another

[boryspower]

Hi,

When adding actions for a button it looks like it is possible to sequence them ("promove/demote") but when I set up actions like this:

Activate Next Sheet

Run Macro (with "ActiveDocument.Reload")

Activate Next Sheet

and I press the button I would expect that I will have sheet switched, than the file reloads and after it finishes reload then sheet is switched again... but it looks like the macro is just run in the background and button skips to the next action on the list...

How to have the actions in sequence to be run one after previous finishes?

I need to run three actoins:

Set Variable

Run Macro (with reload)

Launch (external app)

The external app should be run after macro finishes work (after document is reloaded)

BR

boryspower

[kaushiknsolanki]

Hi,

     You can try this.

     In a button action you can keep 2 actions from your list i.e

     Set Variable

     Reload the application.

     Now you put the thrid action on Document Trigger.

     Go to Document properties->Triggers -> On Post Reload.

     Add the last action on post reload.

Regards,

Kaushik Solanki    

[boryspower]

Hi,

Thanks for answer, but unfortunately I cannot do like this... I also reload this application through other buttons (where Reload is the last action per button) and I don't want that "Launch" to be triggered after those reloads....

I thought if I could put all of this actions into Macro... How to launch external app (*.cmd file) from Macro?

boryspower

[kaushiknsolanki]

Hi,

     One thing I would like to tell you that Macros may and may not work in Browser (Access Point), and also QlikTech Doesnt support it.

     So use it carefully.

Regards,

Kaushik Solanki

[boryspower]

Yes, this I know... I heard it many times from consultants that they don't support it and Macro functionality will be switched off in some future version... In my opinion Macros are very powerfull and QlikTech should ensure that QlikView can serve all VBS functionality as a standard.

boryspower

[kaushiknsolanki]

Hi,

     I agree that Macro is a very powerful thing which should be their in tool and thus QlikView has it too, but powerful things are not easy to understand and implement, and you may never know how the end users are implementing them.

     If you dont use it in proper way, it may corrupt your application and considering this no Product developer will support this.

Regards,

Kaushik Solanki

[#7]

Hi,

Try a macro that pauses the application, for example in your button:

Set Variable

WAIT

Run Macro (with reload)

WAIT

Launch (external app)

In my app, i use this:

ActiveDocument.GetApplication.Sleep 5000

Hope that help.