Making the date a part of the file name

  • Thread starter Thread starter Mick
  • Start date Start date
M

Mick

Does anyone know if there is a way to make the date/time a
part of the file name using symbolics (i.e filename_%
date%.xls) instead of having to key it in manually?
 
Try this code, it worked for me

ActiveWorkbook.SaveAs ActiveSheet.Range("the cell number"),

you will need to format the cell referenced to the date and time forma
you want. Good luc
 
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

Transfer text with count 3
automatic linking to many files 5
Save as a new format name automatically 2
Export html page to Excel - support files folder 1
Referring the cell instead of typing the sheet name 3
Import 4 Different Excel Files from One Folder 0
Extract specific information from the body of outlook mail to an Excel File using VBA 0
Comparing two daily files by changing the cell address 5

Back
Top