[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

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