VB and VBA Users Source Code: Check if an Excel Workbook is Open
[
Home
|
Contents
|
Search
|
Reply
| Previous | Next ]
VB/VBA Source Code
Check if an Excel Workbook is Open
By:
Andrew Baker
Email (spam proof):
Email the originator of this post
Date:
Wednesday, June 28, 2000
Hits:
679
Category:
Office
Article:
To see if an Excel Workbook is open use: Function WorkbookOpen(WorkbookName As String) As Boolean On Error Resume Next WorkbookOpen = CBool(Len((Workbooks(WorkbookName).Name))) On Error GoTo 0 End Function
Terms and Conditions
Support this site
Download a trial version of the Excel Workbook Rebuilder
