Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
(in word 2003) linking to an embedded word document in excel
(Office 2003)
I have a 3 word documents embedded in 3 seperate excel documents. I have a seperate word document that is not embedded. I want to paste links to some text which is in those embedded objects (in the excel files). Word will paste the text, but the when the file is opened, and the links are updated, word says it can't find the files. I didn't move them. Sometimes this works the way I want it to, but rarely. When it works properly, and then doesn't, it's really confusing. I can't find what I'm doing differently. I have tried to narrow it down, but it really seems like I am doing it exactly the same and word is randomly choosing which links will remain intact. |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
(in word 2003) linking to an embedded word document in excel
It is still very unstable and inconsistent. I'm working on another way to get
rid of that double nesting. It's annoying because I'm receiving these excel files with the word embedded in them, and there is nothing I can change about them, they come in new every month, and I have to make another word file based on their data. I could copy and paste, but it would take a while. How can I make it so the embedded word documents (in the excel files) get saved somewhere external to the excel files automatically? Maybe a script or macro? ....but I can't put a macro in the excel files, because they're new every month... "John McGhie [MVP - Word and Word Macinto" wrote: Did you remember to SAVE the target files after linking to them? For this to work, Word needs to surround your link target with a bookmark and save that to the disk. I wouldn't do this: as you have discovered, it's not stable. I would link the external word files to both the spreadsheet and the other word document. In other words, have only ONE level of nesting. Currently you have two: you are linking to a file that contains a file. Link only to the outer file and you will have better luck. On 3/2/07 6:38 AM, in article , "DC" wrote: (Office 2003) I have a 3 word documents embedded in 3 seperate excel documents. I have a seperate word document that is not embedded. I want to paste links to some text which is in those embedded objects (in the excel files). Word will paste the text, but the when the file is opened, and the links are updated, word says it can't find the files. I didn't move them. Sometimes this works the way I want it to, but rarely. When it works properly, and then doesn't, it's really confusing. I can't find what I'm doing differently. I have tried to narrow it down, but it really seems like I am doing it exactly the same and word is randomly choosing which links will remain intact. -- Please reply to the newsgroup to maintain the thread. Please do not email me unless I ask you to. John McGhie Microsoft MVP, Word and Word for Macintosh. Business Analyst, Consultant Technical Writer. Sydney, Australia +61 (0) 4 1209 1410 |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
(in word 2003) linking to an embedded word document in excel
One of the delightful (and bloody confusing...) things about Excel is that
its macros do not have to be in the current workbook :-) If you create a macro in Excel and save it to a Workbook in your Excel startup directory, it will be available to any workbook you open. Hop down the corridor to the good folks at m.p.excel or m.p.excel.links or m.p.excel.programming and ask the experts how to do this properly. I would also investigate setting up a folder on a public file share to which THEY can save the Excel files and from which YOU can open them. That way you don't have to "move" the Excel files anywhere and their embedded links should break less often. But really, I have never found a need to embed a Word file in an Excel spreadsheet. The other way around, yes (that's not stable either, but at least there's a good reason for doing it...) but Word in Excel? Why? What are they doing that requires Word files, and more to the point, requires them to be embedded? :-) Cheers On 6/2/07 2:10 AM, in article , "DC" wrote: It is still very unstable and inconsistent. I'm working on another way to get rid of that double nesting. It's annoying because I'm receiving these excel files with the word embedded in them, and there is nothing I can change about them, they come in new every month, and I have to make another word file based on their data. I could copy and paste, but it would take a while. How can I make it so the embedded word documents (in the excel files) get saved somewhere external to the excel files automatically? Maybe a script or macro? ...but I can't put a macro in the excel files, because they're new every month... "John McGhie [MVP - Word and Word Macinto" wrote: Did you remember to SAVE the target files after linking to them? For this to work, Word needs to surround your link target with a bookmark and save that to the disk. I wouldn't do this: as you have discovered, it's not stable. I would link the external word files to both the spreadsheet and the other word document. In other words, have only ONE level of nesting. Currently you have two: you are linking to a file that contains a file. Link only to the outer file and you will have better luck. On 3/2/07 6:38 AM, in article , "DC" wrote: (Office 2003) I have a 3 word documents embedded in 3 seperate excel documents. I have a seperate word document that is not embedded. I want to paste links to some text which is in those embedded objects (in the excel files). Word will paste the text, but the when the file is opened, and the links are updated, word says it can't find the files. I didn't move them. Sometimes this works the way I want it to, but rarely. When it works properly, and then doesn't, it's really confusing. I can't find what I'm doing differently. I have tried to narrow it down, but it really seems like I am doing it exactly the same and word is randomly choosing which links will remain intact. -- Please reply to the newsgroup to maintain the thread. Please do not email me unless I ask you to. John McGhie Microsoft MVP, Word and Word for Macintosh. Business Analyst, Consultant Technical Writer. Sydney, Australia +61 (0) 4 1209 1410 -- Please reply to the newsgroup to maintain the thread. Please do not email me unless I ask you to. John McGhie Microsoft MVP, Word and Word for Macintosh. Business Analyst, Consultant Technical Writer. Sydney, Australia +61 (0) 4 1209 1410 |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
(in word 2003) linking to an embedded word document in excel
Thanks a lot for your help.
The word files are embedded in excel because they are coming from 3 other sources, I wish I could ask them to change it, but thats the way they want to do it. My solution was: I pasted a link to an excel file in a word file. the linked excel file contains a macro that opens all the excel files I need. Now the macro in the word file that I wrote, opens the link, and the link auto-opens all the 3 files, and the word macro then saves the embedded files in a seperate location. then I run a macro that closes all excel and word files, open up my word file which now has links to the saved files. seems to work, doesn't QUITE work as nice as I'd like it too. There is still the problem of redundant data. How do I get a Word macro to delete an entire section/entire paragraph? Thanks. "John McGhie [MVP - Word and Word Macinto" wrote: One of the delightful (and bloody confusing...) things about Excel is that its macros do not have to be in the current workbook :-) If you create a macro in Excel and save it to a Workbook in your Excel startup directory, it will be available to any workbook you open. Hop down the corridor to the good folks at m.p.excel or m.p.excel.links or m.p.excel.programming and ask the experts how to do this properly. I would also investigate setting up a folder on a public file share to which THEY can save the Excel files and from which YOU can open them. That way you don't have to "move" the Excel files anywhere and their embedded links should break less often. But really, I have never found a need to embed a Word file in an Excel spreadsheet. The other way around, yes (that's not stable either, but at least there's a good reason for doing it...) but Word in Excel? Why? What are they doing that requires Word files, and more to the point, requires them to be embedded? :-) Cheers On 6/2/07 2:10 AM, in article , "DC" wrote: It is still very unstable and inconsistent. I'm working on another way to get rid of that double nesting. It's annoying because I'm receiving these excel files with the word embedded in them, and there is nothing I can change about them, they come in new every month, and I have to make another word file based on their data. I could copy and paste, but it would take a while. How can I make it so the embedded word documents (in the excel files) get saved somewhere external to the excel files automatically? Maybe a script or macro? ...but I can't put a macro in the excel files, because they're new every month... "John McGhie [MVP - Word and Word Macinto" wrote: Did you remember to SAVE the target files after linking to them? For this to work, Word needs to surround your link target with a bookmark and save that to the disk. I wouldn't do this: as you have discovered, it's not stable. I would link the external word files to both the spreadsheet and the other word document. In other words, have only ONE level of nesting. Currently you have two: you are linking to a file that contains a file. Link only to the outer file and you will have better luck. On 3/2/07 6:38 AM, in article , "DC" wrote: (Office 2003) I have a 3 word documents embedded in 3 seperate excel documents. I have a seperate word document that is not embedded. I want to paste links to some text which is in those embedded objects (in the excel files). Word will paste the text, but the when the file is opened, and the links are updated, word says it can't find the files. I didn't move them. Sometimes this works the way I want it to, but rarely. When it works properly, and then doesn't, it's really confusing. I can't find what I'm doing differently. I have tried to narrow it down, but it really seems like I am doing it exactly the same and word is randomly choosing which links will remain intact. -- Please reply to the newsgroup to maintain the thread. Please do not email me unless I ask you to. John McGhie Microsoft MVP, Word and Word for Macintosh. Business Analyst, Consultant Technical Writer. Sydney, Australia +61 (0) 4 1209 1410 -- Please reply to the newsgroup to maintain the thread. Please do not email me unless I ask you to. John McGhie Microsoft MVP, Word and Word for Macintosh. Business Analyst, Consultant Technical Writer. Sydney, Australia +61 (0) 4 1209 1410 |
#6
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
(in word 2003) linking to an embedded word document in excel
There is still the problem of redundant data. How do I get a Word macro to delete an entire section/entire paragraph? "Selection.Delete" :-) The real question is "How do I get a macro to FIND a redundant section?" That can be tricky. I assume you're meaning within the documents you have saved out. If this were to be easy, the redundant section would begin with a heading that never changes, so you could use Selection.Find to find it. Ideally, the following section would also begin with a non-varying heading. So you use Find to find the first and bookmark it, then the second, and bookmark it. Then you Select the first bookmark and extend the selection to the second bookmark, then delete. But you're going to tell me it's not that simple, aren't you? :-) So I'll need accurate details of the content of the document. Cheers -- Please reply to the newsgroup to maintain the thread. Please do not email me unless I ask you to. John McGhie Microsoft MVP, Word and Word for Macintosh. Business Analyst, Consultant Technical Writer. Sydney, Australia +61 (0) 4 1209 1410 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting WordPerfect 12 files to Word 2003 | New Users | |||
Reveal codes in a word document | Microsoft Word Help | |||
take yet another lesson from wordperfect "reveal codes" | Microsoft Word Help | |||
Why can't I get Multiple instances of word? | Microsoft Word Help | |||
I am having difficulty with deleting headers and footers | New Users |