Adding Date to exported file not quite right

[coach32]

I have the following code and I was hoping someone could let me know what I have missed as it gives me an error, saying that it is the wrong data type for one of the arguments.
I'm using Excel and Access 2010. I am just trying to export a table to Excel that will have the Date tacked on at the end of the file name.

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, "tbl_SiebelAlert", "\\MEL21A001PPN\abn\CISC\Siebel Alert\SENT\Add Siebel Alert ", Format(Date, "ddmmyyyy"), True

[CJ_London]

change the , before Format to an &

note you also need to include the file type (.xlsx)

you may also want to consider changing the format to yyyymmdd so files can be easily ordered in the directory

[coach32]

Thank-you very much. Greatly appreciated.

[coach32]

I have updated the code to read

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, "tbl_SiebelAlert", "\\Siebel Alert\SENT\Add Siebel Alert ", & Format(Date, "dd-mm-yyyy") & "xlsx"

I am receiving a "Compile Error: Expected: Expression" and the first '&' is highlighted.

[CJ_London]

reread my post and you will see what you haven't done

[coach32]

Sorry, I misread the comma for punctuation. All good now.
Thank-you once again.