VBA to get part of the path and part of the filename to open a file

[SandsB]

OK, so I have a drop down in cell A1 to select the year and another dropdown in B1 to select the first part of a filename and a third dropdown in C1 to select the second part of the filename

So if select...
A1 = 2019
B1 = Donors
C1 = April

...and the file I want to open is E:\ReportFolder\2019\Donors April.xlsx

What would be the VBA to open this file?

 

[njimack]

 Workbooks.Open ("E:\ReportFolder\" & Range("A1") & "\" & Range("B1") & " " & Range("C1") & ".xlsx")

 

[Fluff]

How about

Sub SandsB()
   Dim Pth As String, Fname As String
   
   Pth = "E:\ReportFolder\" & Range("A1").Value & "\"
   Fname = Range("B1").Value & " " & Range("C1").Value & ".xlsx"
   Workbooks.Open Pth & Fname
End Sub

 

[SandsB]

Thank you.
People like you have helped me so many times here.

 

[Fluff]

You're welcome & thanks for the feedback