Open .docx from Excel form using partial filename

[pnmng49]

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.

[Norie]

Why not use Application.GetOpenFileName?

[pnmng49]

Thanks for your reply.

I tried the Application.GetOpenFilename method and it allows the user to scroll to the file name and click to open it. Problem is that the folder containing these files contains several hundred files. Is there a way to use the "OrgID" (which is the first part of each file name) so that only the files which begin with that number are listed? This would eliminate the need to scroll throughh a list of hundreds of files.

[G e r a r d]

If you have that many files, is it not better to arrange the file in folders named after there "OrgID"
Than picking the right file with the Application.GetOpenFilename will be much easier.

[pnmng49]

Thanks for the reply.

The folder is named "Audit Reports". It contains more than a thousand docs (two per OrgID); when the folder is opened the files are arranged by ascending OrgID number because the OrgID is at the beginning of the file name. This arrangement still requires the user to scroll down to the correct orgID and choose which of the two docs he wants. I was hoping to create a macro that would allow the user to enter an OrgID into an input box and list only the files beginning with that OrgID (or at least automatically scroll to the part of the list showing that OrgID). The user could then select which file from the two he wanted and click to open it. Is this possible?

[G e r a r d]

You could put all file names on a sheet and then filter them...

But are you aware there is some kind of filtering in the explorer? When inside the folder select first file you see and punch in the first characters of the file you need. Explorer jumps to the first file with the combination you typed in.

[pnmng49]

Thanks,

Solution:
Call Shell(pathname\explorer.exe, 1)

Windows explorer opens, user enters first few characters of file name (which are the OrgID) into the search box. User is presented only those file names which begin with the OrgID and can click to open the file selected.