View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Documentation of Excel Object Model and calling it from VB.NET

http://search.microsoft.com/search/r...=0& s=1&swc=0

--
Regards,
Tom Ogilvy

"Peter Nolan" wrote in message
oups.com...
Hi All,
I am about to develop an app in VB.NET (2003) and what it is going to
do is to read a whole series of sheets in an XL spreadsheet and
generate create view statements amongst other things....

What I wanted to do was write the app in vb.net rather than inside the
xlsheet in vba. One major reason being the IDE for .net.

I have already written a similar kind of app with Business Objects VBA
object model.

My questions a
1. Is there a PDF or similar document of how to access Excel via VBA
calls from VS.net somewhere I can download it? I've searched
microsofts site and didn't find it.

2. Does anyone know where there might be an example application written
in vb.net to read an excel spreadsheet posted on the web? Anything
that would just contain the basics of how to read an excel workbook via
vb.net?

The access I need to excel is really simple, I just want to read
through rows in sheets from top to bottom, nothing complicated. The
complicated bit is all the code I need to generate out the other end.

Any tips/guidance most welcome!!!

Best Regards

Peter Nolan