VBA macro for copying file from remote server (From shared folder) to local machine

[Abhishek Tripathi]

Hello fellas,
I am working on a project where in i am using an excel to fill my activities information. This excel consist of numerous sheet and is accessible to different user who are involved in this project. My objective is to write a macro which creates a backup file for this each time this workbook is accessed in the local machine of the user who is accessing the file.

Is there any way by which it can be done using VBA in excel (write a macro in the workbook itself which on running creates a back up file in the local machine of all the users).

I will be thankful to you, if you can provide me the way or macro for completing my job. I have googled a lot, couldn't find the solution.

Please help me
FYI: I have not cross posted this query in any other forum.

 

[vletm]

Abhishek Tripathi
This would be one possible...
Read 'hint's careful before do something!
1) Copy this files ThisWorkbook's code to Your files ThisWorkbook's code.
2) Your file have to have 'Backup'-sheet or change as needs to code
(this uses that sheets cell A1.)
3) There have to be backup-folder to get 'backup' or actually versions.
4) You can name 'any folder' to code instead (now) ActiveWorkbook.Path
5) You can test this by run Do_BackUp,
which would run normally while opening Your file.
6) This would keep max 50 versions of Your file to backup-folder