| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number of workbooks open
Is there VBA code that will return the number of workbooks
that are currently open? Thanks in advance. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to tell the number of current open workbooks... | Excel Worksheet Functions | |||
| When I open Excel, workbooks open automatically. How can I stop t | Excel Discussion (Misc queries) | |||
| Excel 2003 Workbooks.Open with CorruptLoad=xlRepairFile fails on Excel 5.0/95 file due to Chart, with Error 1004 Method 'Open' of object 'Workbooks' failed | Excel Programming | |||
| Workbooks.Open closes other workbooks | Excel Programming | |||
| Workbooks.Open / .Open Text - How do you stop the .xls addition? | Excel Programming | |||
![Tim U[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
