export with date name

[Pam Coleman]

I have an Access query that has a criteria that will ask for a specific date,
then pull out the data and create a make table. Question: I have a macro
that runs that query, asks for the date, and then creates the table. I then
export this into an excel spreadsheet and saves it to a server. I want it to
export it with the date that I put in the criteria, but it only gives it the
table name. Is there a way to do this? I know I can run my query with
date() and it will export and name the spreadsheet with the date it was run,
but this is not what I want. Thanks,

 

[Klatuu]

Your question is unclear, where do you want the date to show up?