|
-
August 6th, 2001, 07:27 AM
#1
How to get the open Excel-instances?
I save different data in Excel-files from my VB-application.
I access Excel through the following object variable:
Dim xlApp as Excel.Application
Set xlApp = CreateObject("Excel.Application")
Is there a way to determine whether xlApp is instantiated or how many instances have been created?
Unfortunately IF xlApp = Nothing Then ... doesn't work.
I want to make sure, that I can close all the Excel-instances in case of an error.
Michael
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|