| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
#name? errors on spreadsheet
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 |
|
#2
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
|
#5
|
|||
|
|||
|
Here is the link: =Word.Document.8|'\\VHAPROFPC1\LABORATORY\P&LM
POLICIES\General Lab\P&LMS POLICY 1 - SCHED CGS WKNDS, HOLID, VACA.DOC'!'!OLE_LINK25' I attempted to "bookmark" but it said that it could not parse the file. -- 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 |
|
#6
|
|||
|
|||
|
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 |
|
#7
|
|||
|
|||
|
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 |
|
#8
|
|||
|
|||
|
Cool. I couldn't figure it out!! :)
******************* ~Anne Troy www.OfficeArticles.com "John Gentile" wrote in message ... 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 |
|
#9
|
|||
|
|||
|
well, thanks for your help. You did point me in the right direction.
-- 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: Cool. I couldn't figure it out!! :) ******************* ~Anne Troy www.OfficeArticles.com "John Gentile" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Spreadsheet Dilemma | Excel Discussion (Misc queries) | |||
| Scan and copy cells from one spreadsheet to another. | Excel Discussion (Misc queries) | |||
| Some exported records do not show on spreadsheet | Excel Worksheet Functions | |||
| Errors accessing shared speadsheet. | Excel Discussion (Misc queries) | |||
| Applying Existing Password to New Spreadsheet | Excel Discussion (Misc queries) | |||
Linear Mode
