Hi all,

I'm looking for some help resolving an issue I have with opening a filename which has 'version control' so the filename's numeric value at the end is forever changing. This numeric value also operates with a decimal, so for example we're on 1.1 currently.

Below is the code I have but I need some advice on what I can do about the changing number, ultimately the code to open the filename OPEN THIS ONE *

The text for the filename required is unique in the folder I'm searching as the others are archived, it's just the version number that changes but there will only ever be 1 version in the folder. Potentially human error could mean two are in there so potentially an ON ERROR piece might be needed, which again I'm open to suggestions for how best to work that in.


Sub Openfile()

    Workbooks.Open Filename:= _
        "Q:\folder\folder\folder\folder\filename &NUMERIC VALUE&.xlsx"

End Sub
Thanks in advance, and please do ask if you need any further clarification.

Dave