topic Re: VBA code to activate qlikview sheet in QlikView

VBA code to activate qlikview sheet

udaya_kumar — Mon, 15 Jul 2013 10:35:40 GMT

Hi,

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

Thanks in advance.

Re: VBA code to activate qlikview sheet

Siva_Sankar — Mon, 15 Jul 2013 10:46:27 GMT

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

Re: VBA code to activate qlikview sheet

paulyeo11 — Mon, 15 Jul 2013 12:56:05 GMT

Hi sir

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

paul

Re: VBA code to activate qlikview sheet

udaya_kumar — Mon, 15 Jul 2013 13:05:17 GMT

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

Re: VBA code to activate qlikview sheet

paulyeo11 — Mon, 15 Jul 2013 14:28:38 GMT

Hi Kumar

Thank you for your reply.

so VBA = micro ?

Re: VBA code to activate qlikview sheet

Thu, 20 Mar 2014 16:56:21 GMT

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

Thanks!!!