By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,313 Members | 1,113 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,313 IT Pros & Developers. It's quick & easy.

How to read Excel spreadsheet embedded in another spreadsheet

P: n/a
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

Feb 5 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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

--
Newbie Coder
(It's just a name)
Feb 6 '07 #2

P: n/a
On 5 Feb 2007 15:44:53 -0800, "GH" <do*******@hotmail.comwrote:

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)
Feb 6 '07 #3

P: n/a
GH
On Feb 6, 7:09 am, Paul Clement
<UseAdddressAtEndofMess...@swspectrum.comwrote:
On 5 Feb 2007 15:44:53 -0800, "GH" <dotnet...@hotmail.comwrote:

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

Feb 6 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.