ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Number of workbooks open (https://www.excelbanter.com/excel-programming/302896-number-workbooks-open.html)

Tim U[_2_]

Number of workbooks open
 
Is there VBA code that will return the number of workbooks
that are currently open?

Thanks in advance.

George Nicholson[_2_]

Number of workbooks open
 
Workbooks.Count

--
George Nicholson

Remove 'Junk' from return address.


"Tim U" wrote in message
...
Is there VBA code that will return the number of workbooks
that are currently open?

Thanks in advance.





All times are GMT +1. The time now is 01:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com