search files across multiple sheets and open & highlight by inputbox

Possibly...

Please Login or Register  to view this content.

thanks but when I write the file name it gives me it doesn't existed I'm sure about the same name whether in sub folder or sheet "PDF"
the same thing I use copy and paste to avoid the wrong writing the name capital or small letters , do you have any idea?

Try just selecting the cell with the file name.

I select the cell what I look for it doesn't change

I changed this version to choose the file by typing in the name instead of selecting a cell.

Please Login or Register  to view this content.

gives error type mismatch in this line

HTML Code: 

Try

Please Login or Register  to view this content.

it gives me doesn't existed file I'm sure about the file name is existed in directory and inside the sheet

The displayed message shows the path and filename it could not find. Is it the path and file name you expected?

Possibly a different approach...

Please Login or Register  to view this content.

thanks so much for you following to solve my problem
honestly I no know where is the problem I run the code in my PC in post#8 in version office 2019 it doesn't open the file and when I run another PC and the version office 2010 it works excellently I tested the code in post # 11 iI don't prefer open by browser because if I have many files it's difficult to find the file but in post #8 it's great ,so I would final thing I would highlight by red color the cell which contains file name what I look for it before this message

HTML Code: 

and when open the file it the color is gone

Please Login or Register  to view this content.

after show this message

HTML Code: 

it shows error and open the file normal without highlight before the message and I can't see which line debug

When you click on 'Debug' what line is highlighted?

I follow by F8 and this stop at this line

HTML Code: 

Try

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

unfortunately still the error shows in the end of code , and i have a note when I run f8 it should highlighted by red color when reach after this line

HTML Code: 

but it's nothing happens , do you have any idea why doesn't highlight by red ?

Probably because it could not find the file name

but if it's so then doesn't the open file the problem all of the steps by F8 from begnning search the sheet to ending open the file work normally and show the error in end the code without highlight the color and returns

I don't know why. Can you post this workbook?

this is my file

Try this...

Please Login or Register  to view this content.

awesome !! you're super great buddy
you've given me a big favor many thanks for astonishing code

Glad to know it works for you!