Macro function call from another qvw macro

[Anonymous]

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

[marcus_sommer · Accepted solution]

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

[Anonymous]

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