Send to CSV with today's date variable

Tue, 20 Aug 2013 02:21:07 GMT

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

Re: Send to CSV with today's date variable

Wed, 21 Aug 2013 01:55:07 GMT

Any Idea???