How to pass QV variable to macro

Wed, 01 Dec 2010 20:51:29 GMT

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.

How to pass QV variable to macro

Wed, 01 Dec 2010 21:01:31 GMT

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() ;

topic How to pass QV variable to macro in QlikView

How to pass QV variable to macro

How to pass QV variable to macro