LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default How to know if Excel is still attached?

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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
attached a file to an excel document -maybe Wanna Learn Excel Discussion (Misc queries) 3 January 20th 09 05:10 PM
Unwanted Excel Spreadsheet Attached Canuk Excel Discussion (Misc queries) 2 January 30th 08 06:22 PM
Counting numbers with a letter attached in excel pano Excel Worksheet Functions 13 January 14th 07 11:16 AM
Open an excel attached to an email [email protected] Excel Programming 1 October 23rd 06 02:45 PM
cannot open excel files attached to outlook Ohio Ray Excel Discussion (Misc queries) 1 July 27th 05 01:51 PM


All times are GMT +1. The time now is 03:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"