I get an error on the worksheet activate method, I don't know why. If I have only 1 worksheet I get no errors.
Below is sample code
;
$aSheets = _Excel_SheetList($g_oWorkbook)
If @error Then
$g_LogMsg = "Error - cannot get list of worksheets"
Return
EndIf
$SheetCnt = UBound($aSheets)
For $SheetX = 1 To $SheetCnt
$g_oExcel.StatusBar = 'processing sheet ' & $SheetX
$g_oWorkbook.WorkSheets($SheetX).Activate ; <---- I get a crash here