Excel In VB.net

6 Apr 2005 4:07 PM

Atley

I am trying to create a new spreadsheet in Excel using VB.net 2003.

This application has to be useable by a range of users running anywhere from
Excel 2000 to Excel XP to Excel 2003.

My dev machine has Excel 2003.

How do I get the libraries for the earlier version of Excel? VB.net 2003
has Excel 5.0 library in it, but I cannot find any documentation on that
particular library set anywhere. It doesn't allow me to put information in
my Cells, it tells me that they are values and are not editable, plus I get
'Member Not Found' errors when trying to make new workbooks or worksheets.

I am very familiar with programming for the newer versions of Excel
(2000-2003). What are my options here?

I don't want to have to install an older version on my dev machine, and I do
not want to have to try and program this app on a differenet machine.

Does anyone have an example of basic sheet creation and formatting in VB.net
for the older 5.0 library? That would be greatly appreciated.

6 Apr 2005 4:39 PM

brix_zx2

..Net 2k3 has Excel 8.0 which works with 2000 and up

Show quoteHide quote

"Atley" wrote:

> I am trying to create a new spreadsheet in Excel using VB.net 2003.
>
> This application has to be useable by a range of users running anywhere from
> Excel 2000 to Excel XP to Excel 2003.
>
> My dev machine has Excel 2003.
>
> How do I get the libraries for the earlier version of Excel? VB.net 2003
> has Excel 5.0 library in it, but I cannot find any documentation on that
> particular library set anywhere. It doesn't allow me to put information in
> my Cells, it tells me that they are values and are not editable, plus I get
> 'Member Not Found' errors when trying to make new workbooks or worksheets.
>
> I am very familiar with programming for the newer versions of Excel
> (2000-2003). What are my options here?
>
> I don't want to have to install an older version on my dev machine, and I do
> not want to have to try and program this app on a differenet machine.
>
> Does anyone have an example of basic sheet creation and formatting in VB.net
> for the older 5.0 library? That would be greatly appreciated.
>
>
>

6 Apr 2005 4:53 PM

Atley

Actually, (I just checked in my COM References) I only have:
Microsoft Excel 5.0 Object Library (VB.net)
and
Microsoft Excel 11.0 Object Library (Office 2003)
avaliable to me... is there a service pack or an update that would give me
the 8.0 OL? that would be ideal.

I have Visual Studio .net 2003 Enterprise Arch.

Thanks for the feedback.

Show quoteHide quote

"brix_zx2" <brix***@discussions.microsoft.com> wrote in message
news:389AB35B-11C7-430E-99BE-A461C98656E3@microsoft.com...
> .Net 2k3 has Excel 8.0 which works with 2000 and up
>
> "Atley" wrote:
>
> > I am trying to create a new spreadsheet in Excel using VB.net 2003.
> >
> > This application has to be useable by a range of users running anywhere
from
> > Excel 2000 to Excel XP to Excel 2003.
> >
> > My dev machine has Excel 2003.
> >
> > How do I get the libraries for the earlier version of Excel? VB.net
2003
> > has Excel 5.0 library in it, but I cannot find any documentation on
that
> > particular library set anywhere. It doesn't allow me to put information
in
> > my Cells, it tells me that they are values and are not editable, plus I
get
> > 'Member Not Found' errors when trying to make new workbooks or
worksheets.
> >
> > I am very familiar with programming for the newer versions of Excel
> > (2000-2003). What are my options here?
> >
> > I don't want to have to install an older version on my dev machine, and
I do
> > not want to have to try and program this app on a differenet machine.
> >
> > Does anyone have an example of basic sheet creation and formatting in
VB.net
> > for the older 5.0 library? That would be greatly appreciated.
> >
> >
> >