Hello,

I am trying to come up with a way to open a file from a specific directory upon clicking a button. The workbooks that I am wanting to open will always be in the same folder, but new versions are updated daily so I want the user to be able to select the specific workbook they are wanting to open. For example, if the user wanted to open "systems check" from the Documents folder the code below works, but If they wanted to open a different file in that location I want the file explorer to open to that file location. Then the user would select the file they wanted.

 Sub Macro2()
'
' Macro2 Macro
'

'
    Workbooks.Open Filename:="C:\Users\ejrice\Documents\systems check.xlsx", _
        IgnoreReadOnlyRecommended:=True, _
        AddToMru:=False
End Sub
Thank you!