VBA macro to create a backup of your open Excel file
In this tutorial I give you the VBA code to easily create backups of an open Excel file. If your file is saved on Microsoft OneDrive, Excel automatically saves all changes you make to the file so that you can easily return to an earlier version if things go bad. This macro will not work for files saved on OneDrive because there is really no need for it. But if you're working on a locally saved file this will become very handy, creating backups for example before making major changes to your file or before test running a macro. Here's the link to download the text file with the VBA code: https://drive.google.com/file/d/1d22w...
In another video of mine I show you how to add a button on the ribbon to run this or any other macro. Here's a link to that video: • How to add a macro button to the ribb...
Like the video? Buy me a coffee:
https://buymeacoffee.com/yosefkdm
Free software I used for creating this video:
Subtitle Edit (free subtitle editor): https://www.nikse.dk/subtitleedit
OBS Studio (free screen recorder): https://obsproject.com/
OpenShot (free video editor): https://www.openshot.org/