Reference to Excel worksheet from Outlook form

[Long Nguyen]

Hi,

Outlook 2002 sp2; Excel 2002 sp2.

In my custom Outlookform I want to provide a link to an Excel worksheet so
that when users click on it the Excel worksheet would be displayed (i.e
Excel would be run and open the worksheet). Would this be possible? and if
so, please give me idea how?

Thanks
Long

 

[Sue Mosher [MVP-Outlook]]

Yes, it's possible to do by writing code to launch Excel and load the file:

Set objExcel = CreateObject("Excel.Application")
Set objWB = objExcel.Workbooks.Add("C:\myWS.xls")

You could put the file name as the caption for a label control and use its
Click event, using the same technique that's demonstrated for web pages at
http://www.outlookcode.com/d/tips/formhyperlink.htm

 

[Long Nguyen]

Thanks Sue. You are always helpfule.

Regards
Long