Naming a workbook as the current date

[Djflare]

Hey all,

I have an excel workbook, that I want to be saved as with the filename being the current date. I can't seem to get it. Help please!

Please Login or Register  to view this content.

[TMS]

Date will have forward slash (/) separators in it. You'd need to format it with something acceptable like space or underscore ... or nothing.

Regards, TMS

---------- Post added at 05:00 PM ---------- Previous post was at 03:15 PM ----------

Thanks for the rep.


If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[Djflare]

Actually I'm trying to make a macro that will be in a empty workbook. I want the macro to save a whole different workbook. Unforunately, i'm really new to this and only know the activeworkbook and this workbook commands. Here is the path of the workbook that I want saved S:\Production\C9\C9 Coat weight data . Also I want the macro to run automatically when the empty workbook is opened b/c I will have a windows scheduled task opening it every 7 days. Basically my whole object is to save the workbook at S:\Production\C9\C9 Coat weight data every 7 days.

---------- Post added at 02:31 PM ---------- Previous post was at 12:12 PM ----------

Nevermind, thanks for the help.