Hi, I would like to create a button that will help me open an excel file in
my share drive.

For example I would like to program the button that can open
s:\karen\excel.xls
After clicking on the button it automatically open my excel file.

Thanks, K.

Dim strFile As String

strFile = "s:\karen\excel.xls"

Application.FollowHyperlink strFile


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


"E-mail report using Lotus Notes rather t"
<(E-Mail Removed)> wrote in
message news:31A963C2-D350-49F9-A2ED-(E-Mail Removed)...
> Hi, I would like to create a button that will help me open an excel file
> in
> my share drive.
>
> For example I would like to program the button that can open
> s:\karen\excel.xls
> After clicking on the button it automatically open my excel file.
>
> Thanks, K.

Just set a hyperlink to that file, and then formate the link so that it looks
like a button, ie. apply the Raised formatting and the same colour as the
usual buttons. You won't get the "pressing button down" effect, although I
suspect that could be programmed as well, but at least it works.

"E-mail report using Lotus Notes rather t" wrote:

> Hi, I would like to create a button that will help me open an excel file in
> my share drive.
>
> For example I would like to program the button that can open
> s:\karen\excel.xls
> After clicking on the button it automatically open my excel file.
>
> Thanks, K.