Good evening all,
I've been working on a file tracking spreadsheet for the last few days and I am having a bit of difficulty with something I would like a macro to do.
The basic idea of the current macro is to generate a checksum .sfv file containing filenames and CRC32s for various files and automatically give it a filename matching a template and containing today's date. For example:
D:\SFV\A_File_With_Word_Docs-[2011-10-04].sfv
D:\SFV\A_File_With_Excel_Docs-[2011-10-04].sfv
This bit I have got working perfectly - however I would like to find a way of adding to this so that when a new file is being created by the macro, the 'existing' file (with a different date in the filename, most likely) is automatically either copied to another folder (as backup) and deleted, or is moved to this backup folder in one move.
For example, on creation of A_File_With_Word_Docs-[2011-10-04].sfv, the existing file A_File_With_Word_Docs-[2011-10-03].sfv from yesterday is automatically detected (with a wildcard most likely) and the actions performed.
I really hope that this is possible as it is a little beyond my knowledge of VBA at this stage! Thank you in advance for anybody who can help me; please let me know if you need any additional information that I may have forgotten to mention.
Bookmarks