word files with embedded excel objects

[mike d]

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

 

[Doug Robbins - Word MVP]

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]

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]

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