incorporating todays date in filename

[emcf]

morning all,

is there any way that i can incorporate today's date in the name of a file that i want to export to an excel file? i presume date() must be involved somewhere but i can't work out how to do it.
the export is going to be done via on click of a command button......

thanks,



woo-hoo!! it be friday!!

 

[Mile-O]

In what format do you want the date to be?

 

[emcf]

i need the filename to be along the lines of "financelist 241003.xls"....basically just any format of date as long as it is there.

thanks,

 

[Mile-O]

A simple example would be:

DoCmd.TransferSpreadsheet acExport, 8, "MyTable", "FinancialList" & Format(Date, "ddmmyy"), True

Obviously, though, you'd need to put the whole path into the filename.

 

[emcf]

cheers mile-o

that will do perfect - very much appreciated!!

euan