Results 1 to 2 of 2

Thread: excel

  1. #1

    Thread Starter
    Fanatic Member
    Join Date
    Dec 2002
    Location
    London
    Posts
    678

    excel

    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

  2. #2

    Thread Starter
    Fanatic Member
    Join Date
    Dec 2002
    Location
    London
    Posts
    678
    solved.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width