Can I attach one of my Exel file on a FORM ?

[Martin]

I want to make my Excel file look like a button on the FORM, when click this
button, it will open this Excel. but this Excel file have to be attached
into this Access, because the users' Excel file path is not certain.


Thanks!


Martin

 

[Douglas J Steele]

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"

 

[aaron.kempf]

Excel is a disease.. I mean-- why would you possibly use it for
anythign?

if you really need to please some beancounters; you can use Office Web
Components within Access forms and reports.. it's a very beautiful
combination