Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Send to CSV with today's date variable

Hi All,

I need to send my staright table everytime after reloading to CSV file with today date.

EG: Today----> MyTableData_20/08/2013

       Tomo.----->MyTableData_21/08/2013

So i am done with send to CSV but facing problem to set variables for data.

  //***********************************************************************************************************************************//

Sub X
v=ActiveDocument.Evaluate("=date(Today(),'DD/MM/YYYY')")
ActiveDocument.Variables("Vdate").SetContent v,true

End Sub

Sub CSV
vFile=ActiveDocument.Variables("Vdate").GetContent.String
set sObject=ActiveDocument

set b=sObject.GetSheetObject("CH01")

b.Export "F:\QlikView\Test\MyTableData_"&vFile&".csv",";"
End Sub

  //***********************************************************************************************************************************//

the above query i not help to done this.

kindly help me to sort out this issue

Thanks

1 Reply
Not applicable
Author

Any Idea???