count number of workbooks open
 

I need some VBA code to check how many workbooks are open at the same time.
Can anyone help, please.

Thanks

count number of workbooks open
 

Sub test()
MsgBox Application.Workbooks.Count
End Sub

Note that addins are not part of the visible workbooks collection.

HTH. Best wishes Harald

"Ronaldo" skrev i melding
...
I need some VBA code to check how many workbooks are open at the same
time.
Can anyone help, please.

Thanks

count number of workbooks open
 

Note that this will include any hidden workbooks such as Personal.xls.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Harald Staff" wrote in message
...
Sub test()
MsgBox Application.Workbooks.Count
End Sub

Note that addins are not part of the visible workbooks collection.

HTH. Best wishes Harald

"Ronaldo" skrev i melding
...
I need some VBA code to check how many workbooks are open at the same
time.
Can anyone help, please.

Thanks