OK, I think I've got it working now. The trick is to save the linked document
after you make the link. Now when I close out the spreadsheet and then reopen
it the update is accurate.
--
John Gentile, MS M(ASCP)
Phone: (401) 273-7100 ext 2046
Fax: (401) 457-3069
e-mail:
Laboratory Information Manager
VAMC Providence




"John Gentile" wrote:

I'm sorry, I forgot to mention that I am using Excel 2003 on a Win XP.
--
John Gentile, MS M(ASCP)
Phone: (401) 273-7100 ext 2046
Fax: (401) 457-3069
e-mail:
Laboratory Information Manager
VAMC Providence




"Anne Troy" wrote:

What version are you using? I tested in Excel 2003. And I do think pasting
your link here might be helpful--you know how picky 'puters can be about
symbols and such...
*******************
~Anne Troy

www.OfficeArticles.com


"John Gentile" wrote in message
...
Yes, I get a similar link, but the error only shows up after I choose to
update the links when I open the spreadsheet. I need these links to show
the
dates the document was written and every time we change the date for a
rewrite.
--
John Gentile, MS M(ASCP)
Phone: (401) 273-7100 ext 2046
Fax: (401) 457-3069
e-mail:
Laboratory Information Manager
VAMC Providence




"Anne Troy" wrote:

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