Does File Selection Dialogue box exist in Access?

Hi all,

I am trying to create a form to import an Excel Spreadsheet - basically open
the form, hit the button to open up a file selection dialogue (showing
directory structure and letting you browse to the file you want, that sort of
control), and then putting the file location into a docmd.transferspreadsheet
command to do the actual import. The excel file we'll be importing to Access
will always have the same name and structure, but the users' names may be
different, hence my wanting to use a dialogue box to find the file.

Is this possible? Does the use of such a control exist in Access? And if
so, where do I find it?

Thanks,
Jamie

Look he
http://www.mvps.org/access/api/api0001.htm


--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L



"Jamie Fellrath" wrote in message
...
Hi all,

I am trying to create a form to import an Excel Spreadsheet - basically
open
the form, hit the button to open up a file selection dialogue (showing
directory structure and letting you browse to the file you want, that sort
of
control), and then putting the file location into a
docmd.transferspreadsheet
command to do the actual import. The excel file we'll be importing to
Access
will always have the same name and structure, but the users' names may be
different, hence my wanting to use a dialogue box to find the file.

Is this possible? Does the use of such a control exist in Access? And if
so, where do I find it?

Thanks,
Jamie

Thank you so much! I figured the DLL was out there somewhere...

"Roger Carlson" wrote:

Look he
http://www.mvps.org/access/api/api0001.htm