Accesing Word Document from Excel???

W

wjoc1

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
 
M

moi

The line Application.Run "'PMI Full WkBk.xls'!Sheet291.ProjectSummary
launches an Excel macro from workbook PMI Full WkBk.xls in worksheet
Sheet291.
In there you'll probably find the word doc specs. But isn't it easier to add
a hyperlink to your shape, open the doc, copy the content and dump it in a
new worksheet?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Opening a Word Document from Excel - ??Stumped?? 1
Saving a Word document as PDF from en Excel macro 2
End of Word Document and Append from Excel VB 1
Pasting Selected Excel Cells into a Word Doc 1
writing excel data into word document 1
using excel vba ope a word doc and copy-paste into another word doc 0
Open Word Document using VBA in Excel 6
starting Word from an Excel macro 3

Top