A
Adam White
Word 2000, SP3:
I have a LINK in a Word document. The LINK pulls information from an
Excel spreadsheet (and works fine, as shown below):
{ LINK Excel.Sheet.8 "D:\\Data\\Estimate.xls" Sheet1!Info \a \p \*
MERGEFORMAT }
I would like the name of the spreadsheet to be a FIELD ...
specifically, a REFERENCE to a hidden bookmark containing the name of
the spreadsheet. This is because I'm gonna use the document as a
Template, and I want the spreadsheet name to change each time a new
document is created from the template (via an ASK field).
When I replace the "Estimate.xls" in the LINK shown above with "{ REF
SheetName }" (minus the quotes) I get "Error!Not a valid link". I
inserted the REFERENCE within the LINK using the Insert/Field command
(i.e., I didn't just type in the text shown).
Is what I'm trying to do even possible? If so, what am I doing wrong?
Thanks!
Adam
I have a LINK in a Word document. The LINK pulls information from an
Excel spreadsheet (and works fine, as shown below):
{ LINK Excel.Sheet.8 "D:\\Data\\Estimate.xls" Sheet1!Info \a \p \*
MERGEFORMAT }
I would like the name of the spreadsheet to be a FIELD ...
specifically, a REFERENCE to a hidden bookmark containing the name of
the spreadsheet. This is because I'm gonna use the document as a
Template, and I want the spreadsheet name to change each time a new
document is created from the template (via an ASK field).
When I replace the "Estimate.xls" in the LINK shown above with "{ REF
SheetName }" (minus the quotes) I get "Error!Not a valid link". I
inserted the REFERENCE within the LINK using the Insert/Field command
(i.e., I didn't just type in the text shown).
Is what I'm trying to do even possible? If so, what am I doing wrong?
Thanks!
Adam