Save export file name with variable input

[renjithpl]

Hi All,

The below macro will export the object and save it in the defined location with the file name "abc"

Sub ExportExcel

set obj = ActiveDocument.GetSheetObject("CH646")

obj.ExportEx "C:\Documents and Settings\renjithpl\Desktop\QlikviewExport\abc.xls",5

End sub

My requirement is, i need to save the file name with variable input in my application

something like

obj.ExportEx "C:\Documents and Settings\renjithpl\Desktop\QlikviewExport\"$(vInput)".xls",5

Any help ??

Regards

Ranjit

[Miguel_Angel_Baeyens · Accepted solution]

Hi Ranjit,

Check this code and this code to get the values from variables in Macro and how to use it.

Hope that helps.

Miguel

[renjithpl]

Hi Miguel,

this is what i was expecting. thanks a lot.

vFile = ActiveDocument.Variables("vDate2").GetContent.String

XLDoc.SaveAs "c:\Qlikview\Claro"& vFile &".xls"