Excel Simple question about the .Index statement

[Fatum48]

Hi!

I have a simple question about how to use the .Index in AutoIt code?

Example:

$oExcel.WorkSheets("SheetName").Index

For some reason AutoIt don't want to take it.

More specificly I need to use it this way:

$iLastSheet = $oExcel.WorkSheets($oExcel.WorkSheets.Count).Index

I need an integer variable that will be the index of the last Sheet.

My goal is to loop from the 4th sheet to the last sheet like the following:

For $i = 4 To $iLastSheet

$oSheet = $oExcel.Worksheets($i)

"Some action taken on the sheet ..."

Next

Any help would be verry apreciated!

Thanks!

[water]

Have a look at the function _ExcelSheetList in the Excel UDF.

Func _ExcelSheetList($oExcel)
    If Not IsObj($oExcel) Then Return SetError(1, 0, 0)
    Local $iTemp = $oExcel.ActiveWorkbook.Sheets.Count
    Local $aSheets[$iTemp + 1]
    $aSheets[0] = $iTemp
    For $xx = 1 To $iTemp
        $aSheets[$xx] = $oExcel.ActiveWorkbook.Sheets($xx).Name
    Next
    Return $aSheets
EndFunc ;==>_ExcelSheetList

[Fatum48]

Thank you very much Water for this quick reply.

But you will laugh at me cause I'm laughing at me myself!

I pass the whole night coding and in fact the .index statement is working as it should!

The reason why nothing was working is that I forgot to put call statement to my Func in my code!

I was trying to debug with some MsgBox and of course the reason why no MsgBox was showing and also no error was showing is that my Func was not even called at a single point of my script!

I'm sorry it's my big mistake!

[water]

Don't worry!

That's something that happens to me from time to time as well