I have a file that exports data - 2 to 3 times a day. Exporting to excel is my preference

Have the reports exported is easy enough, but is there a way to have the files automatically named differently every time? I am picturing the report name with the date and time of export as part of the file name

You could declare a string variable and then use something along the lines of...

?Format(now(),"mmm-dd-yyyy_hh-nn")Feb-07-2019_17-39

Of course, you'd have to put all the other pieces in there, but that should give you some idea.If you want just the date (and not the time), use DATE() instead and change the format string (remove the hhnn stuff)

DoCmd.OutputTo acOutputQuery, "EXPORT Comments on Open PO's for back up", "ExcelWorkbook(*.xlsx)", "H:\PDEPLOY\MMS Database\NOTES ON ORDERS FROM DATABASE\notes on orders from spreadsheet.xlsx", False, "", , acExportQualityPrint

well, the blue text above is the filepath and name that you're outputting the data to, correct? so add the following to your code (Format taken from MadPiet's post), as