VB and VBA Users Source Code: Test if Excel is open

VB/VBA Source Code
Test if Excel is open

By:	Andrew Baker
Email (spam proof):	Email the originator of this post
Date:	Friday, August 04, 2000
Hits:	650
Category:	Office

Article:
To test if a copy of Excel is currently open use the following: 'Purpose : Test if a Excel is currently open 'Inputs : N/A 'Outputs : Returns True if Excel is Open 'Author : Andrew Baker 'Date : 04/08/2000 22:49 'Notes : 'Revisions : Function ExcelOpen() As Boolean On Error Resume Next ExcelOpen = (GetObject(, "Excel.Application") Is Nothing) = False On Error GoTo 0 End Function
Terms and Conditions
Support this site Download a trial version of the Excel Workbook Rebuilder