Macro to move file(s) based on wildcard description

[samf88]

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.

[mccrimmon]

The below code should do the trick.

Cheers

Please Login or Register  to view this content.

[samf88]

Thanks for the quick reply mccrimmon - the code looks like it could potentially solve my exact problem; the only thing is I am having a bit of difficulty testing it before I implement it into my actual sheet.

Whilst testing, the only changes I have made are:

Please Login or Register  to view this content.

Which returns me a run-time error 53 ("File not found") on this line:

Please Login or Register  to view this content.

Logic would indicate that this would be because there is no file with that filename and with a last modified date less than today; however this is not the case. I created the random file "sfv 0001.txt" and its' last modified date is 04 October 2011, today now being 05 October 2011. Do you have any ideas what the problem might be here? Once I get past this stage I can then re-implement the wild card and use the code over in my real workbook.

Thanks for your help!
Regards

[snb]

Please Login or Register  to view this content.

[samf88]

Thanks SNB,

However I am getting the same runtime error as above; debugger states that it is in this part of the code. Any ideas what I may have done wrong?

Please Login or Register  to view this content.

I am testing this one with a file that I have created called "data_2011_01_01.xls" in "D:\test"

[snb]

If the file hasn't been saved yet, that path part will be empty:
amended code:

Please Login or Register  to view this content.

[samf88]

FANTASTIC snb - I've managed to adapt that perfectly to work now. I think I love you! :D

Thanks to both of you for your amazing help - I'll mark this as solved now.