Thread: Error retrieving value of the specified Excel cell (Not active)
View Single Post
  #2   Report Post  
Posted to microsoft.public.vb.general.discussion,microsoft.public.excel.programming
Slava Solovei Slava Solovei is offline
external usenet poster
  
Posts: 1
Default Error retrieving value of the specified Excel cell (Not active)
try

oExcel.ActiveWorkbook.ActiveSheet.Cells(11, 7).Value


--
At least one sentence in this post is wrong, but it could be this one
(paraphrased).
"Jack" <replyto@newsgroup wrote in message
...
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) ?




Reply With QuoteReply With Quote