VBA - Open an unknown file name with known date in

Hi,

I would like to be able to open an file name from a known directory that has an unknown file name in, but a date that is known within the file name. For example the file name would be "finish_sdfsdfsd_userx_YYYYMMDD_xxxxxx.txt" where the date is the YYYYMMDD that is known and the rest of the file name would change.

The date will always be in the same number of characters from the end of the file path.

Normally I would use something along the lines of:

Please Login or Register  to view this content.

Where refFILE was reference on a spreadsheet to include the date. However this will only work with a known file name.

Any ideas as to how to do this. Your help is very much appreciated