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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Documentation of Excel Object Model and calling it from VB.NET
Peter,
There is a new Apress book out by Ty Anderson called Office 2003 Programming Real World Applications. It covers many aspects of Office but it has a chapter on a Timesheet system using Excel. You might find this helpful as it works from start to finish. Read about it at http://www.apress.com/book/bookDisplay.html?bID=343 -- HTH RP (remove nothere from the email address if mailing direct) "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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Documentation of Excel Object Model and calling it from VB.NET
BTW, should have mentioned that it is Office 2003 based, but as .Net is only
supported since 2002, and the 2003 support is much more extensive, you have probably already made that assumption. -- HTH RP (remove nothere from the email address if mailing direct) "Bob Phillips" wrote in message ... Peter, There is a new Apress book out by Ty Anderson called Office 2003 Programming Real World Applications. It covers many aspects of Office but it has a chapter on a Timesheet system using Excel. You might find this helpful as it works from start to finish. Read about it at http://www.apress.com/book/bookDisplay.html?bID=343 -- HTH RP (remove nothere from the email address if mailing direct) "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 |
Reply |
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 |