Macro to search for specific file name

Hi everyone!

I'm new to this forum and I need your help.

I want to create macro to serch for files with known names through folders on my computer. I'm working for valve design company. Very often I have to search multiple folders in different locations to find technical drawings I need. Usualy I have to find 17 different drawings for parts for one valve. It takes around an hour to find all the files I need.

I've found and modify a macro which can search, list and open files with selected extension. I would like to add 17 textboxes (for each part) and use names along with the file extension to find all the drawings.

I'm new to VB and I know only basics. I'm using excel 2013

Sorry for my bad english.

Is an Excel macro the best choice for this? Is there a specific reason you wish to use Excel?

Maybe it is. Maybe not. I'm just asking. But my first thought is there is most certainly already a specific program that will do a more efficient job than anything you might put together in Excel.

What operating system are you using? If it's Windows, try this link, for starters: http://windows.microsoft.com/en-us/w...-finding-files

(My second thought is that you need a more efficient method to name your folders and your files. It shouldn't take that long, ideally, to find what you need.)