NFS79
01-13-2013, 08:26 AM
Hi, please forgive me if there is an easy way to do this but I'm new to VBA, trying to teach myself as I need it...
I've got a file "Quality and Productivity metric data.xlsm" that I have written a macro to push specific data to other sheets as needed. it's quite involved (or it is for me) and while it seems to run fine, there will be other users working with my workbook as well.
what I'd like to do as a first step of my macro is to save a backup of my master file before the macro does anything.
the idea being that if the macro fails catasrophically then I can easily go back to where i was...
I'd like to keep this backup in the same location as the original, and I would like to replace the backup file when the macro is run again - I only need to keep the latest file, no need to keep a bunch of revisions.
can anyone help with this? thanks to everyone on this site, I've gotten a lot of information from reading others posts!
I've got a file "Quality and Productivity metric data.xlsm" that I have written a macro to push specific data to other sheets as needed. it's quite involved (or it is for me) and while it seems to run fine, there will be other users working with my workbook as well.
what I'd like to do as a first step of my macro is to save a backup of my master file before the macro does anything.
the idea being that if the macro fails catasrophically then I can easily go back to where i was...
I'd like to keep this backup in the same location as the original, and I would like to replace the backup file when the macro is run again - I only need to keep the latest file, no need to keep a bunch of revisions.
can anyone help with this? thanks to everyone on this site, I've gotten a lot of information from reading others posts!