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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

File SaveAs 1
File name being changed 2
Simplify save code 11
File Save As macro for users with different paths 6
Export text with current date 1
Open File with name incorporating ~yesterday's date 2
Problem saving backup file with VBA 1
Backup with date-time 9

Back
Top