Make back up of excel using macro
Closed
ujo
Posts
8
Registration date
Wednesday July 15, 2009
Status
Member
Last seen
September 23, 2009
-
Sep 5, 2009 at 12:15 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 6, 2009 at 09:15 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 6, 2009 at 09:15 PM
Related:
- Make back up of excel using macro
- Excel date format dd.mm.yyyy - Guide
- Spell number in excel without macro - Guide
- Macro excel download - Download - Spreadsheets
- Transfer data from one excel worksheet to another automatically - Guide
- Excel blinking cell without macro ✓ - Excel Forum
1 reply
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
810
Sep 6, 2009 at 09:15 PM
Sep 6, 2009 at 09:15 PM
try this macro
the path D:\excell
is only an example folder. change it to your folder
sub test() Dim fname fname = "d:\excel\ABC " & Format(Now, "dd mmm yy hh mm") & ".xls" ThisWorkbook.SaveAs Filename:=fname End Sub
the path D:\excell
is only an example folder. change it to your folder