not activesheet

[emanemos]

Hi,

before I was using the command  $RowCount = $oWorkbook.ActiveSheet.UsedRange.Rows.Count

Now I want to do this command on a particular sheet but not active with

_Excel_RangeRead($oWorkbook,"sheet3", "B" &$j)

Do you know the syntax? with the new version AutoIt

thanks for your help

Edited August 1, 2014 by emanemos

[water]

according to the help file Parameter 2 allows to specify the sheet by name, index or as an worksheet object.

 

$vWorksheet [optional] Name, index or worksheet object to be read. If set to keyword Default the active sheet will be used (default = keyword Default)

 

So "sheet3" should work if this is the name of the worksheet.

[emanemos]

• help with the syntax !!!!

[water]

But your syntax is correct.

Is "sheet3" the name of the sheet you want to read?

[emanemos]

yes but sheet3 is not active !!!!

Edited August 1, 2014 by emanemos

[javiwhite]

$oWorkbook.Sheets(3).select

will make sheet 3 the activesheet.

EDIT:

apologies, I see you want to avoid making this the activesheet. In that case: 

$oWorkbook.Sheets(3).UsedRange.Rows.Count

Edited August 1, 2014 by javiwhite

[water]

For _Excel_RangeRead to work the specified sheet does not need to be active !!!!

[emanemos]

Thanks; You save my life

[water]

What is the value of @error after _Excel_RangeRead?

$sResult = _Excel_RangeRead($oWorkbook,"sheet3", "B" &$j)
MsgBox(0, "Result", "@error = " & @error & @CRLF & "Result: " & $sResult)

Edit: Seems like the problem is solved!

Edited August 1, 2014 by water