VBA code for opening a file with a variable version number in the file name

I have a file that I save with a new version number each time I make major changes. The file name currently is: "Telephony Equipment Inventory v26 (Summary).xlsm". The "26" is the variable number. Can someone give me the vba code to ensure I open the file with the highest version number?

Trish

Hi Trish,

Try the following written and tested using Excel 2003:

Please Login or Register  to view this content.

Lewis

xladept, this failed at the "U = Dir()" line of code. I liked this because it was short, but if this won't work, I will give the longer code a try.

I was unable to get your code to work xladept, so I used Lewis' code. Worked perfectly. Thank you, this will come in very handy again.

Trish