Search file

[Tom.Jones]

Hi,

It's possible to search and open file/s from name of sheet?
Need to type name of sheet and open file/s who have that sheet.

Thanks.

 

[Tom.Jones]

Hi. Totally doable, but will have to take a look when I finish work today.

OK. Thank you.

 

[Dan_W]

OK. Thank you.

Hi

I have updated the workbook at the link I provided earlier. For your reference, I have made two changes to it. First I replaced the Listbox1_DblClick event code with the following:

Private Sub ListBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
    Dim WB As Workbook
    On Error Resume Next
    Set WB = Application.Workbooks.Open(ListBox1.Text)
    WB.Sheets(Me.TBSheetName.Text).Activate
End Sub

Second, I changed the userform's ShowModal property to False. The newly opened workbook appears to be unclosable if ShowModal is set to True.
Hopefully, that works for you.

 

[Tom.Jones]

Thank you so much Dan_W,

It's perfect.

Thank you.

 

[Dan_W]

You're welcome. Thank you kindly for the feedback.