open file dialog in msaccess vba and pass value to a field

[Guest_imported]

i need the code to open a filedialog and pass the selected file path to a field on a form

 

[petersdaniel]

This code is avaialble at MVP.Org at the following link

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

petersdaniel@hotmail.com
"If A equals success, then the formula is: A=X+Y+Z. X is work. Y is play. Z is keep your mouth shut." --Albert Einstein

 

[IrishJim]

Thanks for the site reference! I love how it works.
I would like to know if there is an extension to prompt the user to pick a particular worksheet tab, if it's an Excel file?
Would it be too much to ask somebody if they've ever gone one step further and imported said worksheet into an Access table?
In Access, I have the following working, in general, but can't figure out how to specify a particular worksheet:
DoCmd.TransferSpreadsheet acImport, 8, stImportTable, _
ExcelFileName, True

Thanks!