Query to Excell

[TheHub]

Hi. I know how to export a query result to an Excel spreadsheet, using the DoComd as this DoCmd.OuputTo acOutputQuery, "#query_name#", acFormatXLS, "#excel_sheet_title.xls#", True. My problem (if you can call it that) is how to append the current date to the name of the spreadsheet. eg DoCmd.OuputTo acOutputQuery, "qry_query_all", acFormatXLS, "Query_all.xls", True.... so the spreadsheet would be Query_all_03072013.xls. Thanks in advance :banghead:

 

[JHB]

What about this:

"Query_all_" & Format(Date, "ddmmyyyy") & ".xls"

 

[TheHub]

Brilliant !! Worked 1st time. Many thanks