Formate a Word hyperlink to an Excel worksheet

[Guest]

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

 

[Graham Mayor]

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

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>