Filename with current Date()

  • Thread starter Thread starter Graham
  • Start date Start date
G

Graham

Its probably a format problem (filenames don't like '/'
etc.

Try using "C:\Data_" & Format(Date, "mmddyy")

instead of "C:\Data_"&Date()&".xls"

Cheers,

Graham
 
thanks Graham, works perfectly.
-----Original Message-----
Its probably a format problem (filenames don't like '/'
etc.

Try using "C:\Data_" & Format(Date, "mmddyy")

instead of "C:\Data_"&Date()&".xls"

Cheers,

Graham

.
Click to expand...
 
Back
Top