first of all hello to everyone, i've used this forum before to help with problems and they all seem to work.
but this one is not something i can find the correct infomation for, i wish to have the back ups when i save the files to go to a different directory to the working files, is this possible and if so how, any help at all would be very welcomed. sorry forgot to mention using office 2007
Ajk
Hi,
Copy and paste this code into the workbook module
check out this site if you don't know where that is
http://www.contextures.com/xlvba01.html
When you close the workbook, the code kicks in and will ask if you want to back up the file, it will then save as the file name and todays date..
Please Login or Register to view this content.
C:\Backup\
folder must exist for the macro to work, or you will get an error because it can't find that directory
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks