Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Documentation of Excel Object Model and calling it from VB.NET
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Microsoft Excel 11.0 Object Library documentation? | Charts and Charting in Excel | |||
Excel 2002 Object Model | Excel Programming | |||
"Excel.Application" Object Model | Charts and Charting in Excel | |||
Excel object model | Excel Programming | |||
Excel Object Documentation | Excel Programming |