Macro "Output File" name

  • Thread starter Thread starter TotallyConfused
  • Start date Start date
T

TotallyConfused

I hope this can be done. I have a macro that outputs a copy of a table to
excel. I would like to have a datestamp on the file name. I would like the
date stamp to be added either when I copy the table or when saving. I want
this to be done automatically. Thank you
 
Use as expression for the File Name argument of the macro:

="C:\MyFolder\MyFileName" & Format(Date(), "mmddyyyy") & ".xls"
 
Back
Top