Query export automatically to Excel with today's date

[chris23892 via AccessMonster.com]

the more I look around for this answer, the more confused I get.

Here's what I want to do:
1.) Create a command button on my main form
2.) When this command buttom is pressed, run a query and export the output of
this querry to excel with the file name query_today's date.

I know this can be done, but all these threads are just confusing me more and
more.
Thanks!

 

[chris23892 via AccessMonster.com]

never mind, figured it out. Any one know how to have the Excel file save to
the current date?

 

[Klatuu]

="Query_ & Format(Date,"yyyymmdd")

Use the above as part of the filename argument. Notice the yyyymmdd format.
That is so the files will sort in chronilogical order.

 

[steve.g.waters]

never mind, figured it out. Any one know how to have the Excel file save to
the current date?

So how did you do it?