VBA里面如何获取已经打开的EXCEL文件的个数

2025-03-20 22:30:20
推荐回答(1个)
回答1:

Workbooks.Count

If Workbooks.Count > 1 Then
For i = 1 To Workbooks.Count - 1

Workbooks(i).Close

Next i
Else
Application.Quit

End If