Checking the titles of the workbook

[Legacy 93538]

Hi

Does anyone know how to look in a location and open the file which has the highest version number?

In the folder location StrFldr i have three folders called:
Input_Reference_Table_V1.xlsx, HDE_PPIII_Input_Reference_Table_V2.xlsx,
HDE_PPIII_Input_Reference_Table_V3.xlsx

I wanted to know whether it is possible in VBA to say go to StrFldr and open the file called Input_Reference_Table_*.xlsx which has the higest version number.

I also need to save the file but with a new version number. Does anyone know how to save a file using the filename but incrementing the number by 1?

Thanks....i hope this makes sense

Jessicaseymour