Hi:
Does anyone know how to format a Word hyperlink to open a specific Excel
worksheet? The workbook has a dozen sheets, and I'd like the hyperlink to
open just one of them. In Excel, the address for a worksheet is
[workbook.xls]worksheet
but this of course does not work for Word. I would rather not use VB, if
possible.

Thank you,
LHollister Sallwasser

Select the first cell on the sheet in question and paste to the clipboard -
Paste as Hyperlink in Word
or
{HYPERLINK "C:\\path\\workbook.xls" \l "Worksheet!A1"}
or
if using the insert Hyperlink dialog in Word, insert the address as
C:\path\workbook.xls#worksheet!A1
in the relevant box and add your display text in the appropriate box as
required.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


LHSallwasser wrote:
Hi:
Does anyone know how to format a Word hyperlink to open a specific
Excel worksheet? The workbook has a dozen sheets, and I'd like the
hyperlink to open just one of them. In Excel, the address for a
worksheet is [workbook.xls]worksheet
but this of course does not work for Word. I would rather not use
VB, if possible.

Thank you,
LHollister Sallwasser