topic Re: Macro to open a new qlikview document in QlikView

Macro to open a new qlikview document

Wed, 20 Sep 2017 16:58:11 GMT

Hi at all,

Now i would like, with the same macro, open a new qlikview document specifyed for that excel. The macro should be able to:

1. open a new qlikview document

2. give it the excel in input

Please, help me

Thanks

Lorenzo

el_aprendiz111 — Wed, 20 Sep 2017 21:46:03 GMT

Hi Lorenzo

SUB OpenQV
set app=activedocument.getapplication
set newdoc=app.opendoc("C:\xxx\xxx\yy\yy\y\file.qvw","","")
newdoc.activatesheetbyid "SH09"
END SUB

Fri, 22 Sep 2017 15:38:25 GMT

Hi Fer,

thanks for your answer, but i must ask you a clarification:

- how can i fill in the path? What do you mean with (,"","")?

- Why this newdoc.activatesheetbyid "SH09"

Thanks in adv,

Lorenzo

el_aprendiz111 — Fri, 22 Sep 2017 17:45:03 GMT

Hi Lorenzo

- how can i fill in the path? What do you mean with (,"","")? Optional

SUB OpenQV
set app=activedocument.getapplication
set newdoc=app.opendoc("C:\xxx\xxx\yy\yy\y\file.qvw")
newdoc.activatesheetbyid "SH09"
END SUB

- Why this newdoc.activatesheetbyid "SH09"

automatically activates the sheet you want, if the document qvw has more than 1