View Single Post
  #4  
Old March 21st 06, 06:58 PM posted to microsoft.public.outlook.program_vba
Michael Bauer
external usenet poster
 
Posts: 435
Default 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


Ads