Hi,

This could be an interesting one for someone!

I have a spreadsheet with an AutoShape and when I click on it it opens
up a word document. This seems to be embedded in the workbook, it is
not an external word doc.

I decided to see what code is required to open this word doc. and
recorded the macro. This is the piece of code:

Application.Run "'PMI Full WkBk.xls'!Sheet291.ProjectSummary"

["ProjectSummary" is the word doc I presume. I cannot find any
"Sheet291"]

Now, what I want to do is call up this word document from another
spreadsheet and copy the contents of it into this new spreadsheet.

Any takers!
Thanks in advance
Liam


--
wjoc1
------------------------------------------------------------------------
wjoc1's Profile: http://www.excelforum.com/member.php...o&userid=15281
View this thread: http://www.excelforum.com/showthread...hreadid=386138