Hello,

I am trying to open a file based on the activecells value in a folder. I got that to work however the folder that I need it to look in I also need it to look in subfolders that part I cannot get to work here is my formula.

Sub Units_Click()

Dim RFI As String
Dim Path As String
RFI = ActiveCell.Value
Path = ("mypath here")


Workbooks.Open Filename:=Path & RFI & ".xls"



End Sub

Can someone please help adjust this formula to search in the main folder and all its subfolders?

Thanks