Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)
-   -   Button linked to a file in Calendar? (http://www.outlookbanter.com/outlook-vba/8853-button-linked-file-calendar.html)

John March 20th 06 06:02 PM

Button linked to a file in Calendar?
 
Is it possible to add a custom button to the tool bar that would launch
someone into an excel file... like a hyperlink? I am an outlook programming
newbie so any help is appreciated

Michael Bauer March 21st 06 07:04 AM

Button linked to a file in Calendar?
 
Am Mon, 20 Mar 2006 09:02:11 -0800 schrieb John:

What do you like to launch in Excel?

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.vbOffice.net --


Is it possible to add a custom button to the tool bar that would launch
someone into an excel file... like a hyperlink? I am an outlook

programming
newbie so any help is appreciated


John March 21st 06 04:19 PM

Button linked to a file in Calendar?
 
I would like to open an excel file from and outlook button... either from the
main (mail) page or the calendar page of outlook Thanks!

"Michael Bauer" wrote:

Am Mon, 20 Mar 2006 09:02:11 -0800 schrieb John:

What do you like to launch in Excel?

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.vbOffice.net --


Is it possible to add a custom button to the tool bar that would launch
someone into an excel file... like a hyperlink? I am an outlook

programming
newbie so any help is appreciated



Michael Bauer March 21st 06 06:58 PM

Button linked to a file in Calendar?
 
Am Tue, 21 Mar 2006 07:19:27 -0800 schrieb John:


You can add a ref onto Excel via Tolls/References and copy this code into
"ThisOutlookSession":

Public Sub OpenXLFile()
Dim xl as Excel.Application
Set xl=New Excel.Application
xl.Visible=true
xl.Workbooks.Open "c:\demo.xls"
End Sub

Via right-click on any toolbar you can customize it, select Commands/Macros
and drag the macro "OpenXLFile" onto the toolbar.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.vbOffice.net --


I would like to open an excel file from and outlook button... either from

the
main (mail) page or the calendar page of outlook Thanks!

"Michael Bauer" wrote:

Am Mon, 20 Mar 2006 09:02:11 -0800 schrieb John:

What do you like to launch in Excel?

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.vbOffice.net --


Is it possible to add a custom button to the tool bar that would launch
someone into an excel file... like a hyperlink? I am an outlook

programming
newbie so any help is appreciated




All times are GMT +1. The time now is 11:28 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com