VBA code to activate qlikview sheet

[udaya_kumar]

Hi,

I need VBA Code to activate qlikview sheet in Excel VBA.

Thanks in advance.

[Siva_Sankar]

Without macro, you can achieve this. To activate qlikview sheet, click on actions tab on the object(button,text box object),select layout activate sheet, in the sheet id, mention the sheet id to activate it. Regards. Siva

[paulyeo11]

Hi sir

i don't quite understand what you said , can you a little bit more. As i also have the same requirement.

paul

[udaya_kumar · Accepted solution]

Hi,

I used the following code and it is working now

Sub Test()

Set App = CreateObject("QlikTech.QlikView")

Set Doc =
App.OpenDoc("D:\SAN\Application\Private\Test1.qvw", "","")

Doc.Activate

Doc.ActivateSheet "SH01"

End Sub

[paulyeo11]

Hi Kumar

Thank you for your reply.

so VBA = micro ?

[#6]

If I will want to activate a object using VBA macro... How you do this??

Thanks!!!