#1. Do you mean you want to start your database program or import your data
from that database into an excel worksheet?

And I would think it would depend on what your database program is and even the
version of excel that you're using.

#2. Yep. But if you're creating a userform to open a file, you may want to
look at application.getopenfilename. It'll show the folders, but it's very easy
to implement.

Rivers wrote:

hi all
i have two questions
1 how do i open a database from inside excel
2 is it possible to populate a listbox with all available files from a
specified folder i.e all files in mydocuments but not including the folders.

thanks alot

this site has helped me no end of times

--

Dave Peterson