Embedding Excel into Word
February 4, 2005 2:50 PM Subscribe
Embedding linked Excel 2003 worksheets in a Word 2003 document for portability is giving me pains! [mi!]
OK, so I have a large Word document that has the embedding links like so:
{ LINK Excel.Sheet.8 “C:\\Documents and Settings\\Administrator\\My Documents\\animals.xls” “Sheet1!R1C1:R4C2” \a \p }
But, if this file is moved to another location, the link is broken. I tried changing the path to %cd%, but that failed. Is there anyway to have a variable path in OLE links?
Many thanks in advance!
OK, so I have a large Word document that has the embedding links like so:
{ LINK Excel.Sheet.8 “C:\\Documents and Settings\\Administrator\\My Documents\\animals.xls” “Sheet1!R1C1:R4C2” \a \p }
But, if this file is moved to another location, the link is broken. I tried changing the path to %cd%, but that failed. Is there anyway to have a variable path in OLE links?
Many thanks in advance!
It looks like changing the name will work for one move, but the link reverts to the exact location and name after that...
posted by estelahe at 9:08 PM on February 4, 2005
posted by estelahe at 9:08 PM on February 4, 2005
Response by poster: Yep, I just found that out. Google's being pretty much no help, which is why I came here. Thanks for the input, though!
posted by hominid211 at 1:07 PM on February 7, 2005
posted by hominid211 at 1:07 PM on February 7, 2005
This thread is closed to new comments.
posted by null terminated at 3:42 PM on February 4, 2005