Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Button to open an excel file in a share drive folder.
0 views
Skip to first unread message
E-mail report using Lotus Notes rather t
Aug 31, 2006, 12:32:01 PM8/31/06
to
Hi, I would like to create a button that will help me open an excel file in
my share drive.
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
Aug 31, 2006, 1:04:28 PM8/31/06
to
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"
<Emailreportusing...@discussions.microsoft.com> wrote in
message news:31A963C2-D350-49F9...@microsoft.com...
Niniel
Aug 31, 2006, 4:40:02 PM8/31/06
to
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.
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.
0 new messages