macro to create a new file with today's date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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"
 
Back
Top