I want to attach an Excel file on the Access Form

[Martin]

No no no. No path used, because I sent the whole Access file to the user,
so, I don't know where they will put it.
Forget the path !

What I want to do is attach an Excel file INTO the Access FORM.

Thank you.

Martin



£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­

Not sure I quite understand what you're asking.

Are you saying that the Excel file will be located in the same folder as the
Access database, so that you need to determine where that is? If so, you can
get that using CurrentProject.Path in Access 2000 or newer, or
Left$(CurrentDb.Name, Len(CurrentDb.Name) - Len(Dir(CurrentDb.Name))) in
previous versions.

On the other hand, if you want the user to be able to search for the Excel
file, take a look at http://www.mvps.org/access/api/api0001.htm at "The
Access Web"

 

[seth]

so you are trying to open an excel workbook on an access form?
if so, on the access form, add the spreadsheet activex control

 

[Guest]

If all you want to do is open an Excel workbook add a command button and set
the Hyperlink property to the full path/name of the file

Sheila