topic Re: Macro help needed ----- High preference in QlikView

Macro help needed ----- High preference

Mon, 04 Nov 2013 15:05:29 GMT

Hi All,

Please find my macro script below:

Sub Test

SET sObject=ActiveDocument

SET b=sObject.GetSheetObject("CH01")

b.Export "D:\Qlikview\StoreData\Sales\Test1_fn3r.CSV",","

End Sub

I need to do one change in the above script that is.

i need to get this file name from variable 'Test1_fn3r'. Please give me a example my variable name will be vFilename.

Thanks in Advance!!!!!!!!!!!!!!

Gysbert_Wassenaar — Mon, 04 Nov 2013 15:20:07 GMT

Something like this:

Sub Test

SET sObject=ActiveDocument

SET b=sObject.GetSheetObject("CH01")

vMyVar = ActiveDocument.Variables("vFileName").GetContent.String

vFileName = "D:\Qlikview\StoreData\Sales\" & vMyFar & ".CSV"

b.Export vFileName ,","

End Sub

Fri, 08 Nov 2013 17:57:51 GMT

Hi Gysbert,

It was timing help thanks alot.