Create Macro to point to an Excel file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!!!
 
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?
 
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.
 
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.
 
Back
Top