Create new workbooks using a template workbook

panama407 Posts 1 Registration date Wednesday August 22, 2018 Status Member Last seen August 22, 2018 - Updated on Aug 22, 2018 at 03:16 PM
 Blocked Profile - Aug 23, 2018 at 05:28 PM

Any chance someone would know how to create a macro that would take an existing excel workbook template with data on Sheet1 and have the macro create new workbooks for each business day for the year? The name for each of the new templates would have a different name such as AGL 09.03.18.xls. Sorry if this question is too general as I am not an excel macro expert.

Thank you,


1 response

Its called Save as: No macro needed.

BTW, you cannot have file name with periods in it, well you can, but good luck!

If you need a more elegant solution, try this:

Sub MacroSave()
dt = Day(Date) & Month(Date) & Year(Date)
ActiveWorkbook.SaveAs Filename:="C:\somefolder\Book" & dt & ".xls", _
FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False
End Sub

Try that!