Excel VBA code for selecting a folder then search & open specified files in that folder

Hi There,

I'm looking for the VBA code that firsts prompts the user to select a folder where the files are stored and then searches for a specified file. The full filename does not always remain, so i need to search with a part name something like Processed-File will be present in the filename.

I'm able to pick the folder where the files are located but not able to automatically select the file that i'm looking for

This is the code i have got so far which isn't working;

Please Login or Register  to view this content.

Appreciate any help in completing this task

Cheers

THis should get you to the next part:

Please Login or Register  to view this content.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Thanks.

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread