(in word 2003) linking to an embedded word document in excel

[Guest]

(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.

 

[John McGhie [MVP - Word and Word Macintosh]]

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.

(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 <[email protected]>
Microsoft MVP, Word and Word for Macintosh. Business Analyst, Consultant
Technical Writer.
Sydney, Australia +61 (0) 4 1209 1410

 

[Guest]

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...

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.

(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 <[email protected]>
Microsoft MVP, Word and Word for Macintosh. Business Analyst, Consultant
Technical Writer.
Sydney, Australia +61 (0) 4 1209 1410

 

[John McGhie [MVP - Word and Word Macintosh]]

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

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...

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.

(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 <[email protected]>
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 <[email protected]>
Microsoft MVP, Word and Word for Macintosh. Business Analyst, Consultant
Technical Writer.
Sydney, Australia +61 (0) 4 1209 1410

 

[Guest]

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.

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

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...

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
(e-mail address removed), "DC"

(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 <[email protected]>
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 <[email protected]>
Microsoft MVP, Word and Word for Macintosh. Business Analyst, Consultant
Technical Writer.
Sydney, Australia +61 (0) 4 1209 1410

 

[John McGhie [MVP - Word and Word Macintosh]]

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 <[email protected]>
Microsoft MVP, Word and Word for Macintosh. Business Analyst, Consultant
Technical Writer.
Sydney, Australia +61 (0) 4 1209 1410