Button linked to a file in Calendar?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Am Mon, 20 Mar 2006 09:02:11 -0800 schrieb John:

What do you like to launch in Excel?
 
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!
 
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.
 
Back
Top