Pinterest Pixel

Create a Backup Using Macros In Excel

Have an important spreadsheet that requires frequent backups and snapshots? You can create a backup using Excel... read more

Download Excel Workbook
Bryan
Posted on

Overview

Create a Backup Using Macros In Excel | MyExcelOnline Create a Backup Using Macros In Excel | MyExcelOnline

Have an important spreadsheet that requires frequent backups and snapshots? You can create a backup using Excel Macros with a single click!

Make sure your Excel has the Developer Tab enabled following this tutorial.

I explain how you can do this below step by step!

What does it do?

Creates a backup copy of the spreadsheet in the specified folder

Copy Source Code:


Sub CreateBackup()

'Create a backup copy on the specified folder with the date today included
'Remember to change the folder directory as well
ThisWorkbook.SaveCopyAs Filename:="C:\ChangeMe\" & Format(Date, "mmddyyyy") & "-" & ThisWorkbook.name

End Sub

Final Result: 

Create a Backup Using Macros In Excel

Exercise Workbook:

Create a Backup Using Macros In Excel | MyExcelOnline

Download excel workbookCreate-a-Backup.xlsm


STEP 1: Go to Developer > Code > Visual Basic

Create a Backup Using Macros In Excel | MyExcelOnline

 

STEP 2: Paste in your code and Select Save.

Make sure to change the directory into a folder that exists for you:

Create a Backup Using Macros In Excel

You can see we have changed this to C:\Data\Create a Backup Using Macros In Excel

Close the window afterwards.

STEP 3: Let us test it out! You can see that we have no files yet in the directory:

Create a Backup Using Macros In Excel

Go to Developer > Code > Macros

Create a Backup Using Macros In Excel | MyExcelOnline

 

Make sure your macro is selected. Click Run.

Create a Backup Using Macros In Excel

 

With just one click, you have generated a backup of your current workbook!

 Create a Backup Using Macros In Excel

 

How to Create a Backup Using Macros In Excel

 

101 Macros Book

If you like this Excel tip, please share it
Create a Backup Using Macros In Excel | MyExcelOnline Create a Backup Using Macros In Excel | MyExcelOnline
Create a Backup Using Macros In Excel | MyExcelOnline
Bryan

Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).

He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.

See also  Convert Selected Range into an Image Using Macros In Excel

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...