Is it possible to use wildcards in a pathname? The problem is, I have been asked to create an application using Access that copies files from one folder to another, using the FileSystemObject and then deletes the original files. I can do this no problem as long as the paths to the folders are known. Unfortunately, mine aren't unknown and need to build them up as follows:

If I have a file called PL-50-12345-A.doc, it would be located in:
N:\Products\50 Mechanical Component\50-123xx\50-12345 Plate Mtg Top Slide Proj\Dev (Mech).

The destination folder would be:
N:\Products\50 Mechanical Component\50-123xx\50-12345 Plate Mtg Top Slide Proj\Current

I somehow need to build up this path using the '50-12345' part of the filename. Now I thought this would be possible but it seems that I can't use wildcards in pathnames.

Forgive me if I am mistaken, this is my first attempt at VBA and I think I've been thrown in the deep end!

Any help would be very much appreciated. Thanks.