topic Re: Save export file name with variable input in QlikView

Save export file name with variable input

renjithpl — Mon, 28 May 2012 09:05:32 GMT

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 — Mon, 28 May 2012 09:09:15 GMT

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 — Mon, 28 May 2012 09:47:44 GMT

Hi Miguel,

this is what i was expecting. thanks a lot.

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

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