Opening latest version of a .txt file in Excel using VBA

[lloydie8]

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

 

[Joe4]

Re-posted here: https://www.mrexcel.com/forum/excel...ers-then-opening-latest-incarnation-file.html

In the future, please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #12 here: Forum Rules).
If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.

I am locking this one since the other has a reply.