Show Folder Contents in Drop Down List

**Mordred** · 05-11-2011, 10:55 AM

Hi all,

I have an input box that the user uses to type in the name of the file that he wants to open. It works but the user just informed me that he would rather have something like a drop down menu that displays all the files in the folder so that he can choose a file instead of trying to remember the name and then typing it in. I'm sure this is possible but I am having troubles.

Regards:
Michael

**tigeravatar** · 05-11-2011, 11:22 AM

Mordred,

I would recommend using the GetOpenFileName and setting a default folder to show:

Please Login or Register  to view this content.

Notes:

Change the strDefaultFolder to the folder you want displayed
If you only want to show Excel files instead of all files, remove the apostrophe in front of filefilter

Hope that helps,
~tigeravatar

**davegugg** · 05-11-2011, 11:33 AM

Here is another method:

Please Login or Register  to view this content.

**Mordred** · 05-11-2011, 11:40 AM

I have meetings to go to for the next couple of hours so I won't mark this as solved yet but I'm sure that both will work. Thanks folks!

**Mordred** · 05-11-2011, 02:24 PM

Yep, works like a charm. tigeravatar's worked really well but davegugg's was a little problematic for me. I couldn't get it to recognize the combo box I was using. At any rate, I appreciate the help and this is solved.

Oh and one more thing, I love that signature of yours davegugg! Does that mean you are winning?