Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need VBA Code to activate qlikview sheet in Excel VBA.
Thanks in advance.
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
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
Hi sir
i don't quite understand what you said , can you a little bit more. As i also have the same requirement.
paul
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
Hi Kumar
Thank you for your reply.
so VBA = micro ?
If I will want to activate a object using VBA macro... How you do this??
Thanks!!!