Accessing embedded Excel Docs

M

michael.jarratt

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
 
O

old man

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging from an Excel file with graphics 1
Embed the same Excel multiple times 0
Excel embedded in Word and Select range to copy 0
size an embedded word doc in Excel 0
Embedding a Word Doc in Excel 2007 2
VB6 app used to open Word docs - capture doc names? 5
How do I set focus (and select text) on a text box on a modeless userform? 0
Modifying chart-Data and formatting 2

Top