Hi guys

I wish to write a macro that opens the latest version of "EGBCIS13.TXT" in Excel. However, all of the different versions of the file are located in sub-folders within "H:\Everyone\SOFTCON PCS".

Can someone please point me in the direction of being able to do this. I've tried a few methods I've seen on Google but to no avail.

Many thanks,
Gareth