Does File Selection Dialogue box exist in Access?

[Jamie Fellrath]

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

 

[Roger Carlson]

Look here:
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/wa.exe?SUBED1=ACCESS-L

 

[Jamie Fellrath]

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