Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to pass QV variable to macro

Hello...I need to pass a variable from QV to a macro we use for exporting images and tables to a specific directory. I have an input box for a variable called vBookName. I need to pass whatever value a user inputs here to the macro. I'd like to use this variable on these lines before ObjectCaption, so that we have unique filenames.

Path =

"H:\CBSIS\Analytics & Reporting\Tools\Monthly Books\Global Functions"&ObjectCaption & "_GF.xls"





expPath =

"H:\CBSIS\Analytics & Reporting\Tools\Monthly Books\Global Functions"&ObjectCaption & "_GF.png"



I'm not too versed in VB script, so any help would be great. Thanks.



1 Reply
Not applicable
Author

You need to get the value from the variable object.

Sorry, but my example is in jScript.







var

Variable = ActiveDocument.Variables("<Variable Name>");

SomeOtherContainer = Variable.GetRawContent() ;