Saving query results to Excel with date as name

[Monica Lemaire]

I am trying to save the results of a query to Excel using a macro that captures the system date and adds it to the end of the filename. Any ideas?