Export with date

[prabhu]

Hello all,

I am new to Access. I have created some daily reports ( 20 different reports) of my team in access and exporting that data to excel with Macros. While exporting, is there any way i can export with date in the file name. Presently, i am adding the date in the file name manually after exporting. Its a time consuming process for me .

please help !!!

 

[FoFa]

You need to resort to VBA, build the filename with the date and then export the results.
Or you could try using a function to return the filename in the macro and build the file name externally (in the function) in VBA. Have not tried using a function in a macro such as that, so not 100% it would work.