Open a Work Book where the name is variable

[Yachrishere]

Hi.
I am looking for a way to open a work book that is in a constantly named folder but the name may alter.
i.e. Roof V4.1.xlsm but a later version could be Roof V5.6.xlsm

The path to the folder won't change, just the file name.
I have tried to make it a string so I can use a wild card but it doesn't recognise it as I get a run time error 1004.

MyFile = Dir("\Roof V*")
    Workbooks.Open Filename:=(ActiveSheet.Range("E11").Value & "\Quoting Files" & MyFile)
[Code]

Cell E11 has the path so it's value works, then the folder "\Quoting Files" is correct but it wont accept [U]MyFile

[/U]Any help on this would be greatly appreciated.

 

[Norie]

Try using the path in Dir.

Dim strPath As String

    strPath = ActiveSheet.Range("E11").Value & "\Quoting Files\"

    MyFile = Dir(strPath & "Roof V*"

    If Len(MyFile)<>0 Then
        Workbooks.Open strPath  & MyFile
    End If

 

[Yachrishere]

Fantastic, that sorted it.
Thanks for the help.