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:
- Create new workbooks using a template workbook
- Create skype account with gmail - Guide
- Create a yahoo email account for free - Guide
- A5 template word - Guide
- Create snapchat account - Guide
- Create new instagram account without phone number - 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!
