Accessing embedded Excel Docs

Hi

I've been hunting for a solution for this for a while and was
wondering if anyone could help. I need to write a script or macro
which will open a MS Word (2003) doc then from with in that doc open
an embedded excel spreadsheet. Unfortunately there are a number of
spreadsheets in the doc and I don't know how to reference the
different ones.
Any suggestions would be gratefully appreciated

Thanks

oldman
Sun Jul 01 22:50:03 CDT 2007

Hi,

Embedded spreadsheets are members of the inlineshapes collection (the same
collection may contain other inlineshapes too.)

You may try examine each inlineshape if its type is a type of
wdInlineShapeEmbeddedOLEObject and then go on from there. Use error handling
to see if you are grabbing the right kind of object (Excel).

Old Man

"michael.jarratt@gmail.com" wrote:

> Hi
>
> I've been hunting for a solution for this for a while and was
> wondering if anyone could help. I need to write a script or macro
> which will open a MS Word (2003) doc then from with in that doc open
> an embedded excel spreadsheet. Unfortunately there are a number of
> spreadsheets in the doc and I don't know how to reference the
> different ones.
> Any suggestions would be gratefully appreciated
>
> Thanks
>
>