View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 292
Default 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