Hi everyone,

I am struggling with trying to open a word doc from an Excel 2007 user form using a partial file name.
The 2007 word docs are saved in a folder named "Audit Reports" with file names like:
123 ABC Co_CompLetter.docx
123 ABC Co_CompReport.docx
987 XYZ Co_RA Letter.docx
987 XYZ Co_RA_Report.docx The number at the beginning of each file name is an Org ID Number and it is what I need to search with. What I would like to be able to do is: Enter an OrgID into an Input Box, list all files that begin with the inputted OrgID, be able to click to open the word file of interest from the list.

Any help would be greatly appreciated.