Search and open a file that can be pdf,word,jpeg etc

Hi,

I am a newbie with macros and trying to learn but it is not easy . What I need to do should be easy but I have no clue how to achieve it.
We have lots of files (pdf,doc,docx,xls,xlsx,jpeg,png), in folders and subfolders. There are many subfolders in the main folder. It is sometimes hard to find the file we need as we need to click many times until we get to the folder we want and open the file.

We are keeping a log of the file names in excel sheet. We need to enter the name of the file we want to open in the inputbox in excel sheet and the code will search for the file name we typed in folder and subfolders and open it for us. That is all we need.

Any help regarding this problem is extremely highly appreciated. Thank you

Hello Leith,

Thanks for the warm welcome and prompt reply. You asked

Do the file names include the file path?
No, they don't include file paths. They have names like DS041008-8332.pdf or PIxxxxxxxxx and other names.

Do you want to search a specific folder and all of its subfolders or an entire disk?
Searching specif folder and subfolders is enough.

Thank you very much for your help

Bump..............

Pls. pls, pls isn't no one willing to help ;(

Hello Jaslake,

Thx for the reply. The main folder is in user/desktop and called Transactions. Subfolders are dynamic, that is new subfolders are created everyday. Main folder is the only fixed one. I have attached an excel sheet in which you can see the file names. They are in red. Obviously we have many rows of those names. Each file name is unique by the way. I know there was a search function for excel 2003 which could also look into sub folders but they have taken out this option in excel 2007 and 2010 unfortunately.

I need to catch the plane now. Traveling in 3 hours. I will reply back in 12 hours or so. Thx for the help.

Hi Jasslakee,

Sorry for not posting the reference for other link. My bad. I am writing this message from the airport, just logged in to see if there was any plane. Took 2 planes, and will take the last one in 35 min. I have a tree actually which i will post it here when i reach hime, Plane is boarding now. Thx again