Unable to close excel
Hi Friends,
I have a vba project and whenever I run that for longer time it doesn't close the excel by pressing 'X' on top and for some user it asks for password when they close from exit excel in menu. Please help how can I solve this issue.
Thanks.
Last edited by harry_1805; 02-17-2012 at 10:15 AM. Reason: :) This is solved, thanks Rory!
Do you have any addins (especially COM addins) installed? Do you still have the problem if you run Excel in safe mode?
Good luck.
Re: Unable to close excel
No I don't have any addins, I do a runtime add for recordset and database in the VBA. Never tried it on safe mode, but how does that help because most of the users are in different geographical locations and they are having problem in closing the excel file.
I'm trying to diagnose your problem based only on what you tell me. If you wish to criticise based on information not provided, I'll leave you to it.
I have a code which closes excel directly from VBA project runtime, but that closes all the excels which are opened. I wanted to close only the current excel where the vba code is running, can that be done?
No iam not criticizing you buddy, i was just asking you how to do it and others users will not be able to run vba on safe mode. Just wanted your advice.
should do that.
Please Login or Register to view this content.
i tired this, it closes all other excels which are opened. That will be inconvenient for them. Code should only close the current excel where the vba code is running.
Rory any idea what to do, or is there a way to clear all memory or variables on vba before I exit this to excel? I can try that out, may be because of memory or variable used it is not closing from excel 'X'.
Oh, I see - you mean workbooks, not all instances of Excel. In that case:
will close the workbook without saving changes. Change False To True if you want to save. Also if you are using recordsets, make sure you close them and their connections before you exit.Please Login or Register to view this content.
Thanks Rory! let me try this out.
Thanks Rory this is working well. Its a good workaround, it doesn't close any other excel except the one were vba is running on. Thanks for helping me out!
Glad to help. Please don't forget to mark the thread solved (see the FAQ link at the top of the page for instructions).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks