Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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