Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Macro help needed ----- High preference

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!!!!!!!!!!!!!!

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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


talk is cheap, supply exceeds demand
Not applicable
Author

Hi Gysbert,

It was timing help thanks alot.