Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.word.vba.general,microsoft.public.excel.programming
|
|||
|
|||
![]()
If doing an Alt+F9 does not cause the display of the table to be replaced by
a field code, then the Excel Sheet was actually constucted in the document using the Insert Microsoft Excel Worksheet button on the toolbar and in that case, there is no external file to which you can create a link. It may be possible however to write a macro to extract the table from the document and save it as a worksheet so that you can link it back into the document. I don't have the code for that lying around however. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "mike d" wrote in message oups.com... Thanks for your reply. This doc is in office xp. If I do a Alt + F9 I can still see the table. If I double click the table it opens the table in excel. How do I view the field codes to make sure? Thanks Mike Doug Robbins - Word MVP wrote: If the Excel objects are embedded (when the field codes are viewed you will see { EMBED Excel.Sheet.# ) there is nothing that you can do because there is no way of telling from that information what is the name and path of the source file from which you could create a link. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "mike d" wrote in message oups.com... I have a user that has ~300 word files. Each of these word files have embedded excel objects in them. The powers that be want a program written that will open these word files and edit hyperlinks that are inserted into the excel objects. Is this doable? Any help getting started would be apreciated. Thanks Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
formula references two embedded excel objects in Word doc | Excel Worksheet Functions | |||
Converting embedded objects in excel versus word | Excel Worksheet Functions | |||
Problem opening Excel file 1 time with embedded Word objects | Excel Programming | |||
Font Changes on Embedded/Linked objects in Word | Excel Programming | |||
Embedded Objects in Excel | Excel Programming |