Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

udaya_kumar
Valued Contributor

VBA code to activate qlikview sheet

Hi,

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

Thanks in advance.

Tags (2)
1 Solution

Accepted Solutions
udaya_kumar
Valued Contributor

Re: VBA code to activate qlikview sheet

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

5 Replies
Siva_Sankar
Honored Contributor

Re: VBA code to activate qlikview sheet

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
Valued Contributor II

Re: VBA code to activate qlikview sheet

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
Valued Contributor

Re: VBA code to activate qlikview sheet

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
Valued Contributor II

Re: VBA code to activate qlikview sheet

Hi Kumar

Thank you for your reply.

so VBA = micro ?

Not applicable

Re: VBA code to activate qlikview sheet

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

Thanks!!!

Community Browser