Macro help needed ----- High preference

[#1]

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 · Accepted solution]

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

[#3]

Hi Gysbert,

It was timing help thanks alot.