Excel with .NET

[Limor Janah]

Hi

in vb6 i used this code:

Dim objEx As Excel.Application
Dim objWb As Excel.Workbook

objEx = New Excel.Application()
objWb = objEx.Workbooks.Add

objWb.ActiveSheet.Range("A2").Select()
objWb.ActiveSheet.ActiveCell.FormulaR1C1 = "text"

I used the Upgrate Wizard and the code remain the same
but it's not working

Does anyone has an exemple code that i can see?

Thanks
Limor

[Iouri]

use late binding
Dim oXL As Object
Dim oBook As Object
Dim oSheet As Object

oXL = CreateObject("Excel.Application")
oBook = oXL.Workbooks.Add
oSheet = oBook.Worksheets(1)
.....