Excel In VB.net

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

[brix_zx2]

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

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

"brix_zx2" <br*****@discussions.microsoft.com> wrote in message
news:38**********************************@microsof t.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.

[sionnach]

Atley,
You’ve probably long since solved this problem, but for anyone who’s interested: An Excel file can be created using a tab separated flat file (should work in all versions of Excel, right back to 95)… in VB.NET, something like this:

Imports System.IO
Imports System.Text
………..

Dim strPath As String = "c:\test.xls"

' Delete the file if it exists.
If File.Exists(strPath) Then File.Delete(strPath)

Dim sw As StreamWriter = File.CreateText(strPath)

sw.WriteLine("Header A" & vbTab & "Header B")
sw.WriteLine("1a" & vbTab & "1b")
sw.WriteLine("2a" & vbTab & "2b")
sw.Flush()
sw.Close()