How to loop through all sheets in a workbook

[kcvinu]

Hi all, 

I would like to know how to loop through all sheets in an excel workbook.

Thanks in advance.

[MikahS]

Have you tried coding anything? If so, please post so that we may have a better idea of how to help you.

[kcvinu]

@Mikah , No. I have not tried yet. Because i have no idea. But i am playing with range read and range find functions. 

[MikahS]

Have a look at _Excel_SheetList

[BrewManNH]

Loop through them and do what? Your question is clear as mud.

[kcvinu]

Hi, I have found the answer by myself.

Local $SheetCount = $WBook.Worksheets.Count
for $i = 1 to $SheetCount
    Local $CellValue = _Excel_RangeRead($WBook,$WBook.Worksheets($i),"B" & $CellNum[0])
    $OutArray[$i] = $CellValue
    
Next

 

 

[water]

That's one possible way to solve the problem ...

[kcvinu]

@MikahS , I think _ExcelSheetList is best for me. Thank you.

[MikahS]

My pleasure.