Create a copy in the same folder when a file is modified and saved

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a excel file shared with multiusers with the write permission. In case
they save the file unintentionally, I want to create a back-up file of the
original one whenever the file is opened and resaved (The back-up file should
be the old one for recovery purpose!).

Is there a function in Excel to do this or need I create a Macro?
 
I just got the answer by looking at posts before. My next question is can I
back up the file into another different folder from the original one?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What are the steps to fix damaged MDF files in SQL Server? 0
Import 4 Different Excel Files from One Folder 0
When saving files, I get a back up of the same file saved as well 1
Saving a newer version of Excel using an older version (Excel 97) 7
Excel CSV Files; Creating Of 3
Excel 2007- can't get it to automatically make backups 1
automatic backup? 2007 version 3
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1

Back
Top