activate a sheet whose id is a variable

[ali_hijazi]

Hello

I need to write a macro in which I want to activate sheets

I know that the syntax is as follows:

ActiveDocument.GetSheetByID("SH03").Activate

however the SH03 I have it in a variable

Please advise

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

Say the variable is named vSheet in the QlikView application. Then the code should look like

Set s = ActiveDocument.Variables("vSheet")
ActiveDocument.GetSheetById(s.GetContent.String).Activate

Hope that helps.

Miguel

EDIT: Note that you can use a direct button action instead of a macro to activate a sheet depending on the value of a variable. Better off using this instead of using macro.