Hyperlinks

[Brian]

How do I reference a specific Chart in an Excel Workbook
in a Word hyperlink? I can create the hyperlink to the
workbook just fine, it's just that I want it to link to a
specific tab in the workbook that is a chart.

 

[macropod]

Hi Brian,

If you select & copy the chart in Excel, then go into the
Word document and use Edit|PasteSpecial|Link, you'll get a
linked version of the chart as an INCLUDETEXT or
INCLUDEPICTURE field, with the correct syntax for the
chart referencing. You'll be able to view the field's
coding by selecting the chart in word and pressing Shift-
F9.

Copy that referencing into your HYPERLINK field (again via
Shift-F9) and things should work OK.

Cheers