CODEWITHSUNDEEP
vbaexcel
Kelsius
Kelsius

Reputation: 473

New Workbook with Date

I want to create a new workbook from a macro that would allow me to place the current date (preferably just the month) into the title of the workbook. Is such a thing possible, and if so, how do I do this?

Upvotes: 0

Views: 37

Answers (1)

Kyle
Kyle

Reputation: 2545

Sub New_WB()
Dim WB as Workbook
Set WB = Workbooks.Add
WB.SaveAs "C:/User/Test/WB name " & Format(Date,"mm") & ".xlsx" 'Fill this in with the path and name that you would like
End sub

This is the general code. Without more information, I am afraid I cannot give you more specific code. This will give you the two number month (ex "02" for February, use "mmm" if you want "Feb" for February)

Upvotes: 1

Related Questions