Reference to Excel worksheet from Outlook form

  • Thread starter Thread starter Long Nguyen
  • Start date Start date
L

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
 
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
 
Back
Top