本帖最后由 JLxiangwei 于 2012-11-17 13:03 编辑
Sub 计数()
Dim Num As Integer
Dim wb As Workbook
Dim d As New Dictionary
For Each wb In Application.Workbooks
Num = Num + 1
d.Add wb.Name, Num
Next
MsgBox "一共有" & Num & "工作薄" & Chr(10) _
& "当前工作薄名称:" & ActiveWorkbook.Name & Chr(10) _
& "序号为:" & d(ActiveWorkbook.Name)
End Sub
新建 Microsoft Excel 工作表.zip
(15.62 KB, 下载次数: 53)