Accessing embedded Excel Docs

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

michael.jarratt@gmail.com - 27 Jun 2007 11:44 GMT

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

Reply to this Message

old man - 02 Jul 2007 04:50 GMT

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

> Hi
>
[quoted text clipped - 7 lines]
>
> Thanks

Reply to this Message