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

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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/6576-can-i-attach-one-my-exel.html


Thanks!


Martin



*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6576
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"

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Martin" wrote in message
news:emCJHwD4FHA.700@TK2MSFTNGP15.phx.gbl...
>
> I want to make my Excel file look like a button on the FORM, when click
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6576
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
>
>