Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening a Word Document from Excel - ??Stumped??
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 -- wjoc ----------------------------------------------------------------------- wjoc1's Profile: http://www.excelforum.com/member.php...fo&userid=1528 View this thread: http://www.excelforum.com/showthread.php?threadid=38647 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening a Word Document from Excel - ??Stumped??
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. -- Regards, Tom Ogilvy "wjoc1" wrote in message ... Hi, I'm hoping someone can help me out with this one. I have an excel spreadsheet which contains an AutoShape. When I click on this AutoShape it opens up a word document. This is not an external file it is somehow embedded in the spreadsheet but I cannot find any reference to it. I decided to recod a macro and click on the AutoShape to see what code 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 document from??? 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=386476 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening word document through excel vba | Excel Discussion (Misc queries) | |||
Opening Word Document with excel | Excel Discussion (Misc queries) | |||
Opening Word with a specific document from excel vba | Excel Programming | |||
opening a word document from excel | Excel Programming | |||
Opening a Word Document in Excel | Excel Programming |