"VBA Research" statistics Excel worksheet count

Iamlaosong

In VBA programming, if you cycle through every worksheet, you need to know the number of worksheets, and the common methods are as follows:

1. Number of worksheets in the current workbook

num = ThisWorkbook.Sheets.Count

This current workbook is the workbook in which the VBA program resides, so how do you count the number of worksheets in other workbooks?

2. Number of worksheets in the active workbook

Windows (Datfile). Activate

num = ActiveWorkbook.Sheets.Count

3. The number of worksheets in the workbook that knows the file name

    Datfile = Cells (1, 5)    datfullname = thisworkbook.path & "\" & Datfile    If Dir (datfullname, vbnormal) <&G T vbNullString then        workbooks.open filename:=datfullname        ' Open order file    Else        MsgBox datfile & ' does not exist! ", vbOKOnly," Iamlaosong "        Exit Sub    End If    num = Workbooks (datfile). Sheets.count

"VBA Research" statistics Excel worksheet count