Finding Excel Content (*with* Worksheet Reference)

[waldemar]

I opened an Excel File like this:

Dim Excel As Object
Set Excel = CreateObject("Excel.application&quot
Excel.workbooks.Open (strFilename)

Now, I', looking for a way to access speific cells in the way

"Sheet!A1" or
"Sheet!A1:B2"

Through the Cells Property I would need split these "Path-References" in columns and lines (Cells(2,2)). Does anyone know a way of using the complete path like this strContent=Excel.Cells("Sheet!A1&quot ??

Thanks a lot in advance!

 

[RobBroekhuis]

Try

strContent = Excel.sheets("Sheet&quot.range("A1&quot

Rob

 

[waldemar]

Thanks Rob. Is this the only way? (Want to avoid the hazzle of parsing the reference strings...)

 

[RobBroekhuis]

No, come to think of it, you can also use:

excel.evaluate("sheet!A1&quot

Rob