Save as in Vb.net as excel object

[benl]

Hi,
Is anyone try to save excel object in vb.net? I have problem below:

I run the code below in vb.net and it have "error: 1004. Exception from HRESULT: 0x800A03EC"

xlsApp = New Excel.Application
xlsBook = xlsApp.Workbooks.Open(Filename:="D:\test.xls", UpdateLinks:=False, ReadOnly:=False)
xlsSheet = xlsBook.ActiveSheet()
xlsSheet.SaveAs(FileName:="D:\commaTEST", FileFormat:="xlCSV")


Thanks for your help...

Ben

 

[stevemannar]

Dim xlApp As Excel.Application
Dim xlWorkBook As Excel.Workbook
Dim xlWorkSheet As Excel.Worksheet
Dim misValue As Object = System.Reflection.Missing.Value

xlApp = New Excel.ApplicationClass
xlWorkBook = xlApp.Workbooks.Add(misValue)
xlWorkSheet = xlWorkBook.Sheets("sheet1")
xlWorkSheet.Cells(1, 1) = "test"
xlWorkSheet.SaveAs("C:\vbexcel.xlsx")

full sourec ... How to create an Excel 2007 file in VB.NET


steve