MS Access, Automation Does not Close Microsoft Excel

Automation Does not Close Microsoft Excel

Author	Message
Marcel Forti #1 / 4	Automation Does not Close Microsoft Excel Thanks for Reading this message. When you use Automation to control Microsoft Excel and you want the instance of Microsoft Excel to close, you must use the Quit method. Otherwise, the instance of Microsoft Excel will remain open and take up resources. I am encountering this issue with Excel but do not wish to use the quit Method because I want Excel to remain open so that the user may manually close the application. Is there away to cleanup after excel without having to use the quit method? Reference File - Technet PSS ID Number: Q145770 Thanks, Marcel Fortin
Mon, 07 May 2001 03:00:00 GMT

Tad Buhma #2 / 4	Automation Does not Close Microsoft Excel Add this line at the end of you code. Set ExcelObject = Nothing TAD Quote: >Thanks for Reading this message. When you use Automation to control >Microsoft Excel and you want the instance of Microsoft Excel to close, you >must use the Quit method. Otherwise, the instance of Microsoft Excel will >remain open and take up resources. >I am encountering this issue with Excel but do not wish to use the quit >Method because I want Excel to remain open so that the user may manually >close the application. Is there away to cleanup after excel without having >to use the quit method? >Reference File - Technet PSS ID Number: Q145770 >Thanks, >Marcel Fortin
Mon, 07 May 2001 03:00:00 GMT

Marcel Forti #3 / 4	Automation Does not Close Microsoft Excel I do use this line in the end of my code, but Microsoft has a bug that it still doesn't close down Excel properly. They recommend using the Quit method to free up these lost resources, but I cannot use this method because i don't accually want the Application to shut down. So I'm looking to see if anyone else knows another way to get around Microsofts Bug. The reference document below describes exactly my problem. Thanks for the help... Marcel Quote: >Add this line at the end of you code. >Set ExcelObject = Nothing >TAD >>Thanks for Reading this message. When you use Automation to control >>Microsoft Excel and you want the instance of Microsoft Excel to close, you >>must use the Quit method. Otherwise, the instance of Microsoft Excel will >>remain open and take up resources. >>I am encountering this issue with Excel but do not wish to use the quit >>Method because I want Excel to remain open so that the user may manually >>close the application. Is there away to cleanup after excel without having >>to use the quit method? >>Reference File - Technet PSS ID Number: Q145770 >>Thanks, >>Marcel Fortin
Tue, 08 May 2001 03:00:00 GMT

Dev Ashis #4 / 4	Automation Does not Close Microsoft Excel Hi Marcel, Unless you close the Excel instance, I don't think you'll be able to get back all the resources. I don't know of any other cleanup methods. If you still want to let Excel open, just make the instance visible at the end. Antoher thing to remember is that subsequent instances of Excel will open quicker. HTH -- Dev Ashish (Just my $.001) --------------- The Access Web ( http://home.att.net/~dashish ) --------------- Quote: >Thanks for Reading this message. When you use Automation to control >Microsoft Excel and you want the instance of Microsoft Excel to close, you >must use the Quit method. Otherwise, the instance of Microsoft Excel will >remain open and take up resources. >I am encountering this issue with Excel but do not wish to use the quit >Method because I want Excel to remain open so that the user may manually >close the application. Is there away to cleanup after excel without having >to use the quit method? >Reference File - Technet PSS ID Number: Q145770 >Thanks, >Marcel Fortin
Tue, 08 May 2001 03:00:00 GMT

Page 1 of 1

[ 4 post ]