I want to attach an Excel file on the Access Form

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/6672-i-want-attach-excel-file-access.html
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"

--
Doug Steele, Microsoft Access MVP
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6672
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
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
>
>

 
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!

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

"Martin" wrote in message
news:ehcDCoN4FHA.3000@TK2MSFTNGP12.phx.gbl...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6672
>
> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6672
> 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
> 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
>>
>>
>
>
>

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

"Martin" wrote:

>
> 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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6672
>
> 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"
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
> "Martin" wrote in message
> news:emCJHwD4FHA.700@TK2MSFTNGP15.phx.gbl...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6672
> >
> > 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
> >
> >
>
>
>
>