Excel In VB.net

A

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.
 
A

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top