LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.sdk,microsoft.public.excel.programming,comp.os.ms-windows.programmer.win32
external usenet poster
 
Posts: 7
Default Should an automated version of Excel close?

Peter T wrote:
Ensure any open workbooks are either saved (or the .Saved property is marked
saved) or use .Close(false).

Release any objects in the order created, eg worksheet, workbook etc.

Explicitly close the Excel instance with .Quit
Then release your reference to Excel.

Yes, what you describe is normal. Without an open workbook the instance will
close when all ref's to it are released, but with an workbook it'll stay
open unless you use "oXL.Quit".

Regards,
Peter T

That's what I was hoping to hear.
--
Norm

To reply, change domain to an adult feline.

 
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
How do I save an Excel 97-2003 version or 2007 version for Mac 200 Bronigal Excel Discussion (Misc queries) 1 December 7th 09 08:04 AM
Macro - Save an Open Excel Version 4 as current version of Excel planomax Excel Programming 1 February 6th 07 09:41 PM
Close Second Version of Excel file Sparkybird Excel Discussion (Misc queries) 1 July 24th 06 10:54 PM
downloaded version excel 2007 will not close normally when shut do Greg Excel Programming 1 May 30th 06 09:56 AM
Recover earlier version of excel sheet after new version saved? stephanie38 Excel Discussion (Misc queries) 3 June 17th 05 03:52 AM


All times are GMT +1. The time now is 06:28 AM.

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"