Export variable to Excel

[Anonymous]

I have a variable called "vAvgPerCountry" that I need to export into Excel using a macro(because I also have other tables to export).
I understand that ActiveDocument.Variables("vAvgPerCountry").GetContent.Var can be used to get the value of the variable, but how do you paste it in Excel?

[devarasu07]

check this steps

http://www.qlikfix.com/2013/09/06/importing-and-exporting-variables/

[sasikanth]

hi,

you can use input box to export a variable to excel,

[Anonymous]

The .qvw file is no longer available for download

[devarasu07]

Hi,

able to downloaded from Rob blog and it's working. FYI refer to the attachment. Tks