Error retrieving value of the specified Excel cell (Not active)

  • Thread starter Thread starter Jack
  • Start date Start date
J

Jack

I am trying to retieve content of specified (row, column) cell.

Set oExcel = GetObject(, "Excel.Application") ' get existing Excel Object

oExcel.Cells(11, 17).Value

The above code works fine in Immediate window but in run time creates error:
'438': Object doesn't support this property or method"

How to retrieve value of the specified cell (Not active) ?
 
Is oExcel.Cells(11,17).Value the whole line or is it something like:

CellValue = oExcel.Cells(11,17).Value

If what you typed is the whole line in your program, then I think that is
your problem, you need to assign the value to something.

Sue
 
Back
Top