SELECT A SPECIFIC WORKBOOK FROM A SPECIFIC FOLDER

[choomkey]

Please help
I am new to excel VBA and I cannot find an example online which solves my dilemma
I would like to press a button which will select a specific workbook from a specific folder
Before pressing the button I would like to use 3 dropdown boxes to select the specific work book name
Dropdown A=1-9, Dropdown B= 0-5, Dropdown C= 0-5
eg. the folder will contain ~324 workbooks with the file names in the following format - TGx yE zL where (x=1to9), (y=0to5), (z=0 to5)
many thanks in advance for your time

 

[Fluff]

Hi & welcome to MrExcel.
How about something like

Sub choomkey()
   Dim Fname As String, Pth As String
   Pth = "C:\MrExcel\Fluff\"
   Fname = "TG" & Range("A2").Value & " " & Range("B2").Value & "E " & Range("C2").Value & "L.xlsx"
   Workbooks.Open Pth & Fname
End Sub

 

[choomkey]

Thankyou Fluff that worked perfectly. Much appreciated. If you don't mind and you have the time could you help me with another challenge.
The various workbooks (actually files containing one sheet) contain rows of numbers (each file has a different numbers of rows). Each row has 10 numbers which vary between (0- 80)
Once I have chosen the file path (A2,B2,C2) and before I press the button, I would like to also choose 2 numbers between (0-80) in cell D2 and E2, and display all the rows which contain those numbers.
many thanks for you help

 

[Fluff]

As that's a totaly different question, it needs a new thread. Thanks