Output To Macro changing file names

[was1]

I'm not familiar with coding and hope it can be done without any.

I'd like to create a Macro that exports a query into an Excel spreadsheet. This Macro needs to be run daily so the file name needs to also add a date to the file name. I tried using "Output To" but didn't know how to modify the exported filename each time. I would like the user just to press a button and it will do everything.

Any help will greatly be appreciated.

 

[PHV]

For me, the simplest way is to use VBA playing with the DoCmd.OutputTo method and the Format and Date functions.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[was1]

Thanks, Is there a way to have it automated in a macro or a button?