Opening a Word Document from Excel - ??Stumped??

W

wjoc1

Hi,

I'm hoping someone can help me out with this one. I have an exce
spreadsheet which contains an AutoShape. When I click on this AutoShap
it opens up a word document. This is not an external file it is someho
embedded in the spreadsheet but I cannot find any reference to it.
decided to recod a macro and click on the AutoShape to see what cod
would be required and I got the following line:


Code
-------------------

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

-------------------


This is the code of the procedure it is running/calling


Code
-------------------

Application.DisplayAlerts = False

Sheets("Front Page").Select
ActiveSheet.Shapes("Object 73").Select
Selection.Verb Verb:=xlPrimary

Application.DisplayAlerts = True

-------------------


Can someone explain to me where it is getting this word documen
from???

Thanks in advance
Lia
 
T

Tom Ogilvy

If it isn't a link, then it is stored in the same file as the xls. That's
why they call it the compound document format.
 

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

Accesing Word Document from Excel??? 1
Opening a PDF from an Excel User Form 2
How can I programatically change the caption on a button? 3
Opening a Word document from Excel 9
Opening a document in Word from Excel 1
Saving a Word document as PDF from en Excel macro 2
Opening a PDF from an Excel User-Form 1
Mail Merge Word Document From Excel VBA 0

Top