Hello, Providence. I go to Wilkes Barre. :)
Does the title have a bookmark name?
It appears to work for me, and leaves this link:
=Word.Document.8|'C:\Documents and Settings\Anne Troy\Desktop\Name of
document.doc'!'!OLE_LINK1'
Which is surrounded by curly brackets.
What is the resulting link for you?
*******************
~Anne Troy

www.OfficeArticles.com

"John Gentile" wrote in message
...
I'm trying to create a spreadsheet to automatically track Word documents'
date. I'm copying the date from the title page and pasting into the Excel
cell using Paste Special and creating a link to the text. It works when I
set
it up, but when I close the spreadsheet and then reopen it the linking
process shows the #NAME? error. How can I correct this?

--
John Gentile, MS M(ASCP)
Phone: (401) 273-7100 ext 2046
Fax: (401) 457-3069
e-mail:
Laboratory Information Manager
VAMC Providence