Good day excel Gurus!
I got a question, probably answer is somewhere at the forum, but I can't find it
So, I ask for your help.
I need a macro that will create a backup copy of excel file in other folder when an original file is closing.
I will appreciate any help!
Thank you in advance
Last edited by kewlc2s; 06-21-2014 at 08:49 PM. Reason: SOLVED
Hi, kewlc2s,
maybe use the event
in ThisWorkbook/DieseArbeitsmappe and SaveCopyAs for saving a copy of the file with a date and time stamp in the given folder.
Please Login or Register to view this content.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Danke HaHoBe
But, maybe there is some other way to solve this problem.
File is used by many users, a lot of them are not familiar with excel, and I afraid that they will delete or change something.
That's why I want to make emergency copy (in other folder), every time when file is closing. Would be really good if name could be dd mm yyyy mm hh
I found a macro for saving Copy, but another question, how I can change directory for saving file?
Please Login or Register to view this content.
Hi kewlc2s,
See if this code helps. I commented it a lot for you to understand. I hope it all makes sense.
This is the code for the actual saving:
Please Login or Register to view this content.
This is the code to make sure the folder you are saving to always exists
ThanksPlease Login or Register to view this content.
Thank you fredlo2010 !!!
Now I understood, thanx a lot !!!
I am glad I was able to help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks