Export query to excel

[Liam87]

Would anyone know how to export a query to excel? I have tried using a macro, however you have to define the file name in the macro, and I don't particularly want users going through macro settings. I was thinking if there was someway to date stamp the end of my file so that it becomes unique? Data will be updated monthly mostly, so each month a new query would be exported.



If anyone has any ideas, would be good. Otherwise I can just keep saving over the one file and having the users 'save as' to the appropriate location. There will only be a handful of users so I guess that won't be too much of an issue

[June7]

I don't use macros, only VBA. Show your macro code for analysis.

Can't you concatenate Date() to the filename specified in the macro?