word files with embedded excel objects

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
Wed Jun 28 12:48:53 CDT 2006

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" <mike.drewery@gmail.com> wrote in message
news:1151496641.427221.145890@m73g2000cwd.googlegroups.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
>

mike
Wed Jun 28 13:23:36 CDT 2006

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" <mike.drewery@gmail.com> wrote in message
> news:1151496641.427221.145890@m73g2000cwd.googlegroups.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
> >

Doug
Wed Jun 28 16:05:30 CDT 2006

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" <mike.drewery@gmail.com> wrote in message
news:1151519016.133733.317560@i40g2000cwc.googlegroups.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" <mike.drewery@gmail.com> wrote in message
>> news:1151496641.427221.145890@m73g2000cwd.googlegroups.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
>> >
>