Button to open an excel file in a share drive folder.

[Guest]

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.

 

[Douglas J. Steele]

Dim strFile As String

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

Application.FollowHyperlink strFile


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


"E-mail report using Lotus Notes rather t"

 

[Guest]

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.