macro to create a new file with today's date

[Pam Coleman]

Is there a way to write a macro that will run a query and then save it to a
server file and name it the date it was ran? Thanks,



I tried to send this once before but it looked like this question did not go
through and the my PC locked up. If it shows up, I'm sorry.

 

[Steve Schapel]

Pam,

You can output the data returned by a query as a text file, using a
TransferText action in your macro. Is that what you want? If so, you
can enter the equvalent of the following in the File Name argument of
the macro...
="D:\YourFolder\" & Format(Date(),"yyyymmdd") & ".txt"