topic Re: Macro to switch between Sheets in QlikView

Macro to switch between Sheets

Mon, 13 Aug 2012 21:36:02 GMT

I need a macro that every 1 minute to switch between nine worksheets, creating a panel, can someone show me an example? That the application must also update their data after a load on the QlikView Server, updating the browser ... Thanks

Re: Macro to switch between Sheets

Alejandro_Hernández — Mon, 13 Aug 2012 22:15:58 GMT

Here's a very simple macro that switches between sheets:

Sub SwitchTab
For x = 0 to 5
ActiveDocument.ActivateSheet x
ActiveDocument.GetApplication.Sleep 1000
ActiveDocument.GetApplication.WaitForIdle
next
End Sub

Re: Macro to switch between Sheets

Tue, 14 Aug 2012 02:44:20 GMT

Thanks for the help, but I need to do something a little more complex, the macro must select each item in a list every 30 seconds and when finish the list items, change the tab, I need to put a specific name for this function it triggers the open QVW? Thanks