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

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

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

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