vb 隐藏sheet 数量

来源:百度知道 编辑:UC知道 时间:2024/06/27 06:25:26
用VB 如何检查出隐藏窗口的数量?

是要查EXCEL的隐藏sheet数量么?
Dim xlapp As New Excel.Application
Dim xlbook As Excel.Workbook
Dim xlsheet As Excel.Worksheet
Dim i As Integer

xlapp.Visible = False
Set xlbook = xlapp.Workbooks.Open("d:\book1.xls")
i = 0
For Each xlsheet In xlapp.ActiveWorkbook.Worksheets
If xlsheet.Visible = xlSheetHidden Then i = i + 1
Next

Debug.Print i

xlapp.Quit
Set xlapp = Nothing