tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
I have an excel sheet in onedrive that i open through file explorer,
I'd like to make a backup copy of the document when i click a button but i'd like it to save to its own folder.
So what i need it this
I click a button it runs the macro
It saves a copy of the document to current location plus adds a new folder called "Backups" if it does not already exist.
please help if you can
p.s. the document is xlsm
thanks
Tony
I have an excel sheet in onedrive that i open through file explorer,
I'd like to make a backup copy of the document when i click a button but i'd like it to save to its own folder.
So what i need it this
I click a button it runs the macro
It saves a copy of the document to current location plus adds a new folder called "Backups" if it does not already exist.
please help if you can
p.s. the document is xlsm
thanks
Tony