Adding date to a csv macro

[#1]

Hi,

How can I add date to my file name in the below macro that exports to csv?

set sObject = ActiveDocument.GetSheetObject("TB01")

sObject.Export "Q:\Cancellations\Cancels.csv",","

Thank you.

[Gysbert_Wassenaar]

See here for an example that adds a date to a file name: http://community.qlik.com/thread/71621