topic Macro function call from another qvw macro in QlikView

Macro function call from another qvw macro

Anonymous — Fri, 15 Jul 2016 09:12:13 GMT

Hi All,

I'm trying to run macro in application by macro from another qvw with no joy.

Everything works fine but macro. Need help.

Thanks in advance

Re: Macro function call from another qvw macro

marcus_sommer — Fri, 15 Jul 2016 11:03:31 GMT

I'm not sure if this would be possible with qlikview and vbs - within excel and vba it's possible but quite difficult. A very easier method then this is to execute all necessary routines from your origin-application. This meant if you open from qlikview another qvw you could run each kind of routine only by referencing to the new qvw:

...

set newdoc = OpenDocEx ("D:\YourPath\YourFile.qvw",2,false,,,,true)

newdoc.Fields("Year").Select 2016

...

This meant instead of referencing a statement to ActiveDocument you referencing now to newdoc.

- Marcus

Re: Macro function call from another qvw macro

Anonymous — Fri, 15 Jul 2016 11:44:16 GMT

Thank you Marcus. As you said, I copied macro to first document, replaced ActiveDocument to NewDocument and it works fine) Thanks again.