I am looking for a way to modify this code to name the export file differently.
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, "qryCombined_forexport", "export.xls"
I am looking for the export file to be export(date).xls
where (date) is the current date of export.
Or can i create a save as dialog box for the user to name the file themselves?
Thanks
Ryan.