Create Macro to point to an Excel file

[John Kirschner]

I need to create something in a form that will allow me to set a field in a
record to point to an Excel file that is outside of the Access database. I
have a table that has the summary points of a excel file, but I would like to
like that summary to the detailed document. I am confused!!!!

 

[Chris Reveille]

I am not sure what you mean. Do you want to open an excel file, display an
excel file or link to fields in an excel file?

 

[John Kirschner]

I would like to have the ability to give the user the choice of attaching a
link to an Excel file to each record that is unique for that record.

 

[Chris Reveille]

FileOpen dialog code you'll find on Dev's site at
www.mvps.org
You can use the "OpenFile" dialog box from Windows to
navigate to the file (instead of the InputBox). The code for doing this is
a bit complex, but is available at The ACCESS Web:
http://www.mvps.org/access/api/api0001.htm

then you can store the selected file in one of your fields as a hyperlink.