Populate ListBox on Form of Files in specificed Dir

[HunterN]

Hi,

I am transferring my modules and forms over from Excel VB to Access and this is what I want to do. I want to:

Set a specific directory to be the directory to look in. Then set the extension = to '.xls'.
Then populate my ListBox with just those '.xls' files it finds. This way the user only has the ability to select certain files.

Then when they select one, I use this filename to open it in a database.

So far I have code that opens a dialog box starting at a certain point. But, I want to limit the files that they see. Plus, I want to make it look just like it did when this form was in Excel.

I would really appreciate an example if someone has one.


Thanks,
Nancy

 

[boblarson]

See if this helps:

http://allenbrowne.com/ser-59.html

 

[HunterN]

Thank you Bob,

I created myself a test database and created the Form. This worked great! It's exactly what I wanted.

Thanks for pointing me in the right direction!

Nancy