How to know if Excel is still attached?

M

Mike Reynolds

My VB.NET app creates and populates a worksheet in Excel each time that it
does it's thing. Every time the user selects a doctor from the list and hits
the OK button, I want another sheet to be created and filled.

So now what if the user closes Excel? At present I am simply reusing the
Excel object, such that if they close Excel my program throws an exception. I
want to be able to trap the exception and either startup a new instance of
Excel or attach to an already running instance of Excel.

Also, how do you trap exceptions for Excel COM calls?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run-time error 1004 from workbook attached to Outlook email 0
Microsoft Office Excel has encountered a problem and needs to close 5
Excel queries 0
Out of resources error message - when not... 3
How to save and close multiple Excel applications? 1
How to copy multiple objects from Excel to PowerPoint 0
Add-in closes first when Excel is closed, causing problems 1
Identifying anc saving workbooks from more than one Excel applicat 0

Top