-
March 13th, 2003, 05:09 AM
#1
Excel with .NET
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
-
March 13th, 2003, 09:02 AM
#2
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)
.....
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|