For Each Loop to Determine If an Excel Workbook Is Open (151336)
The information in this article applies to:
- Microsoft Excel 97 for Windows
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 5.0
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q151336 SUMMARY
The Microsoft Excel versions mentioned at the beginning of this article do
not include a Microsoft Visual Basic for Applications function to
determine
if a workbook is already open. The following sample user-defined function
loops through all of the opened workbooks in memory to determine if a
specific workbook is already open in the current instance of Microsoft
Excel.
Modification Type: | Minor | Last Reviewed: | 10/10/2006 |
---|
Keywords: | kbdtacode kbhowto kbProgramming KB151336 |
---|
|