excel

F

farshad

Well-known member
Joined
May 1, 2003
Messages
109
Location
London
Hi,

In a procedure which opens an excel file and reads the cells I have the following code.
the problem is when using oExcel.Cells(3,4) it reads "System.__ComObject" and not the
value of the cell
I have also tried using .tostring at the end but it is no good.
P.S. I do not want to use oExcel.Range("C3") I would like to use oExcel.cells...

private sub Download

Dim oExcel As New Excel.Application
Dim oWorkBook As Excel.Workbook
Dim oSheet As Excel.Worksheet

oExcel.Workbooks.Open("C:\Farshad\CQS\Projects\Ben\MDSDHist.xls")
oExcel.Visible = True

oExcel.Cells(intRow, intCol + 1)

End SUb

Any thoughts?
Thanks
 
Back
Top