quit excel application

danclemson · Mar 14th, 2002, 07:47 AM

Hi, All

I was trying to quit excel application using Quit method, after working with and closing all its workbooks. The code is simple as following:

excelApp.Quit
Set excelApp = Nothing

I got unhandled exception (access violation) says: "memory xxx refers memory xxx, can't read". So the application has to be closed manually.

What is the problem?
Thanks for all the input. / dan

Al Chara · Mar 14th, 2002, 08:04 AM

Dan,

I am not sure if this is what you want by just try using the following code to quit excel:
Excel.Application.Quit

I hope this helps.
Kind regards,
Al

danclemson · Mar 14th, 2002, 08:33 AM

Al,
Thanks for the reply.

I tried what you said, and still get the same unhandled exception.

I can do all sorts of thing, like adding workbook to the application, getting memory used by the application, except quit the application.

Is there other way to close the application?

Thanks /dan

Al Chara · Mar 14th, 2002, 08:58 AM

Try just using Application.Quit

It works for me. Where are you placing the code?

Mar 14th, 2002, 09:07 AM

i tried the Excel.Application.Quit to quit excel and it does work so i suggest that the other person retries it.

danclemson · Mar 14th, 2002, 09:08 AM

I am using RoseScript, which is Basic Script language similar to VB.

I can't directly use Application.Quit.
It has to be called as:
myExcelApp.Application.Quit or
myExcelApp.Quit

dan

danclemson · Mar 14th, 2002, 09:13 AM

One more thing is that myExcelApp.Quit works fine with my other scripts, but only this one I got memory access violation.

so I don't think there is the problem of syntax. It seems the program can't locate the application when trying to close it. But I can't figure out the reason, as I still can do things like adding workbook on this applicaition.

Thanks /dan

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 14th, 2002, 07:47 AM	#1
danclemson New Member Join Date: Mar 2002 Posts: 11	Hi, All I was trying to quit excel application using Quit method, after working with and closing all its workbooks. The code is simple as following: excelApp.Quit Set excelApp = Nothing I got unhandled exception (access violation) says: "memory xxx refers memory xxx, can't read". So the application has to be closed manually. What is the problem? Thanks for all the input. / dan

Mar 14th, 2002, 08:04 AM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Dan, I am not sure if this is what you want by just try using the following code to quit excel: Excel.Application.Quit I hope this helps. Kind regards, Al

Mar 14th, 2002, 08:33 AM	#3
danclemson New Member Join Date: Mar 2002 Posts: 11	Al, Thanks for the reply. I tried what you said, and still get the same unhandled exception. I can do all sorts of thing, like adding workbook to the application, getting memory used by the application, except quit the application. Is there other way to close the application? Thanks /dan

Mar 14th, 2002, 08:58 AM	#4
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Try just using Application.Quit It works for me. Where are you placing the code?

Mar 14th, 2002, 09:07 AM	#5
Guest Posts: n/a	i tried the Excel.Application.Quit to quit excel and it does work so i suggest that the other person retries it.

Mar 14th, 2002, 09:08 AM	#6
danclemson New Member Join Date: Mar 2002 Posts: 11	I am using RoseScript, which is Basic Script language similar to VB. I can't directly use Application.Quit. It has to be called as: myExcelApp.Application.Quit or myExcelApp.Quit dan

Mar 14th, 2002, 09:13 AM	#7
danclemson New Member Join Date: Mar 2002 Posts: 11	One more thing is that myExcelApp.Quit works fine with my other scripts, but only this one I got memory access violation. so I don't think there is the problem of syntax. It seems the program can't locate the application when trying to close it. But I can't figure out the reason, as I still can do things like adding workbook on this applicaition. Thanks /dan