Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Any Idea???