Hi All,

I want to open the latest version of a file and then do a vlookup in that latest version.

I know how to open the latest file, but once it is open, how do I do a vlookup without specifying that file name? So that I don't have to change the filename in the vlookup all the time?

eg. if VS_10.12.2012.xlsx is the latest version, I want to vlookup in range C10:C20 on tab VS_1.

A new version of the file will be created every week, but the tabs and cells will all remain as they are.

Your help much appreciated!!!

Regards