Create new workbooks using a template workbook
Closed
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
Blocked Profile - Aug 23, 2018 at 05:28 PM
Related:
- How to create a workbook in excel
- How to create a new workbook in excel - Best answers
- When you create a workbook - Best answers
- How to create a serial number generator in excel - Guide
- How to change date format in excel - Guide
- Excel mod apk for pc - Download - Spreadsheets
- How to create a shortcut on desktop - Guide
- How to create viber group - Guide
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:
Try that!
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!
