How to read Excel spreadsheet embedded in another spreadsheet

[GH]

Does anyone know how I can access (using OleDbConnection, I presume) a
spreadsheet embedded in a cell of another spreadsheet (with vb.net)?

Thanks,
GH

 

[Newbie Coder]

Couldn't tell you off the top of my head, but there are many VB.NET articles
with MS Office products on the Microsoft KBase website:

http://support.microsoft.com/search/?adv=1&spid=2965

 

[Paul Clement]

¤ Does anyone know how I can access (using OleDbConnection, I presume) a
¤ spreadsheet embedded in a cell of another spreadsheet (with vb.net)?

The embedded object would have to be extracted to a Workbook file first. There is no way to access
an embedded object using the data access libraries.


Paul
~~~~
Microsoft MVP (Visual Basic)

 

[GH]

¤ Does anyone know how I can access (using OleDbConnection, I presume) a
¤ spreadsheet embedded in a cell of another spreadsheet (with vb.net)?

The embedded object would have to be extracted to a Workbook file first. There is no way to access
an embedded object using the data access libraries.

Paul
~~~~
Microsoft MVP (Visual Basic)

Thanks, Paul, that's what I thought would be the case.

--GH