Open latest version of Word file from Excel

Hi guys I need some help.

I have a VBA code that opens a Word document saved in one of my drives and deletes some data from some tables.

Please Login or Register  to view this content.

My problem is that I have some other code that creates the Word document with a different name if the document already exists, it's some kind of version control code. What I need the above code to do, is open the document with the latest version in its name.

This is what my drive would look like with different versions of the same document:

Testing.jpg


So my goal is to have the code open the "Sandy_Denver 2017_Proposal_v3", which would be the latest version of the document in that folder.

Thanks in advance for any help provided.

Logit thank you so much for your help, what I'm currently looking for is to open the file based on the name of the document with the latest version, not the latest date on the file.

The issue with your code is that not always the document with the latest date will be the latest version of the document I need to have opened using VBA.

I'm not sure if I'm being clear, sorry but I do appreciate your help.