Backup: https://599cd.com/Backup

More specifically in the Extended Cut, Richard copies a file to a folder using VBA. Just replace the file name in that video with the path for your Excel file.

I've used the methods in Richards videos for backup coupled with videos for a timer to force close all open instances to make backups and destroy older backups ( from a month ago eg ) but what I want to do now is backup only the excel files linked to in each record I'm just not completely sure how to send the paths into the module in each loop of the for next loop. Is there a specific video of how to send each record hyperlink field into the module ?
   Is it the same process as in the email videos where he sends each email address into the module in each loop?

Got it working -  incidentally it seems to be able to backup over 1000 excel sheets ( linked to on a hyperlink field in my access database ) faster than I could copy and paste them as a whole. Is that possible?

Yes, it’s definitely possible. You can technically back up as many files as you wish at the same time. Sometimes it might run slower, especially if you have a bunch of loops and other stuff in your database, but it’s just as possible to back up many as it is to back up one.

As far as the hyperlink field goes, yes you can do that, but hyperlink fields are evil. Honestly, I strongly recommend storing the file name in a Short Text field instead, including the full path (C:\YourPath, etc.).

Here’s a link to Rick’s video on Hyperlink fields and why using them are not recommended: https://599cd.com/Hyperlink

Evil Access Stuff: https://599cd.com/Evil

Yes I followed Richards videos on that and they are not hyperlink fields ( sorry for confusion) and also that it is actually working very well, so well in fact that it lead the question if it was possible the access backup of the actual workbooks were faster than I could cut and paste the whole folder cos it definitely seems faster. -- well pleased !

ie over a thousand workbooks copied and pasted in a couple of seconds. I even changed a few figures in some of the sheets to make sure it was backing up the actual sheets and not just checking the links to the sheets are there in the backup folder but all is good and changes are seen in the ones I tampered with. Result!