Microsoft Office, Excel Automation - Problem closing instance of Excel from with Access2000

Excel Automation - Problem closing instance of Excel from with Access2000

Author	Message
@lanti #1 / 5	Excel Automation - Problem closing instance of Excel from with Access2000 I have created a VB routine to read access tables and then create 9 spreadsheets in one workbook and save it. This all works well but when calling the application.quit or in my case xlApp.quit it does not seem to close Excel. When checking in the Taskmanager there is still an instance of excel running. I cannot get my program to close this instance. I have called the quit command and set the instance to nothing , but it still refuses to close. If I exit Access this instance then closes. Any ideas ??? Thanks -- Wayne Mills Information Technology & Financial Services Tel :(043) - 7264088 Cell :0823687481 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system ( http://www.--*.com/ ). Version: 6.0.462 / Virus Database: 261 - Release Date: 13/03/2003
Wed, 14 Sep 2005 21:22:12 GMT

mark stor #2 / 5	Excel Automation - Problem closing instance of Excel from with Access2000 A little confused. You mention it being a VB app, but then you say that you have to exit Access for it to close. is it running in VB or Access ? When I close objects out, I am always explicit on all object references... workbook.close set workbook = nothing application.quit set application = nothing I find doing everything explicit, reduces chance of memory leaks. Mark
Wed, 14 Sep 2005 22:19:35 GMT

Jame #3 / 5	Excel Automation - Problem closing instance of Excel from with Access2000 Quote: >-----Original Message----- >I have created a VB routine to read access tables and then create 9 >spreadsheets in one workbook and save it. >This all works well but when calling the application.quit or in my case >xlApp.quit it does not seem to close Excel. When checking in the Taskmanager >there is still an instance of excel running. I cannot get my program to >close this instance. >I have called the quit command and set the instance to nothing , but it >still refuses to close. If I exit Access this instance then closes. >Any ideas ??? >Thanks >-- >Wayne Mills >Information Technology & Financial Services >Tel :(043) - 7264088 >Cell :0823687481 >--- >Outgoing mail is certified Virus Free. >Checked by AVG anti-virus system (http://www.grisoft.com). >Version: 6.0.462 / Virus Database: 261 - Release Date: 13/03/2003 >. I had a same problem in my vb.net. I found a solution for it. You will have to actually release all the objects from excelapp, worksheet, range, etc. Here is a link to the solution but in C#. http://www.eggheadcafe.com/articles/20021012.asp
Mon, 19 Sep 2005 02:49:17 GMT

MS #4 / 5	Excel Automation - Problem closing instance of Excel from with Access2000 Quote: > I had a same problem in my vb.net. I found a solution for > it. You will have to actually release all the objects > from excelapp, worksheet, range, etc. Here is a link to > the solution but in C#. > http://www.eggheadcafe.com/articles/20021012.asp Hi, This should also answer the question: http://search.microsoft.com/gomsuri.asp?n=1&c=rp_Results&siteid=us/de... t=http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B317109 Peter -- Please post questions to the newsgroup - everyone benefits. This post is provided "AS IS" with no warranties, and confers no rights Sample code subject to http://www.microsoft.com/info/cpyright.htm
Mon, 19 Sep 2005 15:42:15 GMT

Jay #5 / 5	Excel Automation - Problem closing instance of Excel from with Access2000 Wayne's original question had to do with Access 2000 and Excel 2000 and not .Net. While it is nice to develop in .Net for the future some of us still have to work in the older environment. I'll post my question under a separate cover but it relates to this problem - hence my interest. Quote: >-----Original Message----- >> I had a same problem in my vb.net. I found a solution for >> it. You will have to actually release all the objects >> from excelapp, worksheet, range, etc. Here is a link to >> the solution but in C#. >> http://www.eggheadcafe.com/articles/20021012.asp >Hi, >This should also answer the question: >http://search.microsoft.com/gomsuri.asp? n=1&c=rp_Results&siteid=us/dev&targe Quote: >t=http://support.microsoft.com/default.aspx?scid=kb%3Ben- us%3B317109 >Peter >-- >Please post questions to the newsgroup - everyone benefits. >This post is provided "AS IS" with no warranties, and confers no rights >Sample code subject to http://www.microsoft.com/info/cpyright.htm - Hide quoted text - - Show quoted text - Quote: >.
Wed, 21 Sep 2005 03:35:31 GMT

Page 1 of 1

[ 5 post ]