I have code that opens a workbook, this work fine.


If I make structural modifications to the workbook, it is then saved with a version number.
BookName = "\TestFile v1.xlsm"
Workbooks.Open (ThisWorkbook.Path & BookName)
How can I make BookName = "\TestFile v1.xlsm" generic so it would see the highest number after the v.
For example, TestFile v2.xlsm or maybe TestFile v1.1.xlsm

Can I use wild-cards, if so what is the syntax?

Or will I have to hard code each change?