Pinterest Pixel

Create a Backup Using Macros In Excel

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

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


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  Delete Blank Worksheets Using Macros In Excel

Star 30 Days - Full Access Star

One Dollar Trial

$1 Trial for 30 days!

Access for $1

Cancel Anytime

One Dollar Trial
  • Get FULL ACCESS to all our Excel & Office courses, bonuses, and support for just USD $1 today! Enjoy 30 days of learning and expert help.
  • You can CANCEL ANYTIME — no strings attached! Even if it’s on day 29, you won’t be charged again.
  • You'll get to keep all our downloadable Excel E-Books, Workbooks, Templates, and Cheat Sheets - yours to enjoy FOREVER!
  • Practice Workbooks
  • Certificates of Completion
  • 5 Amazing Bonuses
Satisfaction Guaranteed
Accepted paymend methods
Secure checkout

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...