John Walkenbach:
Tip #29
http://www.j-walk.com/ss/excel/tips/tip29.htm

--
Regards,
Tom Ogilvy

"Mike Fogleman" wrote in message
...
I have an Excel workbook that consist of 3 sheets of forms to fill out.
These forms must be updated quarterly. I am going to use a database query
to
pull the info needed into the workbook. The problem is for the user to
select the correct system and quarter for the query to update the forms.
The question is can I use VB to open the file directory browser and use
his
selection to drive which database file to query? If so, what code is used
to
accomplish this?