View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Application.quit

Close all applications and
Try deleting all the files in your temp folder.

Then reboot.

--
Regards,
Tom Ogilvy



"cush" wrote:

I recently added to the Workbook_Before_Close procedure the following code ---

----------
----------
ThisWorkbook.Save
Application.Quit



Now, when I open Excel, I get an error msg: PERSONAL.XLS is locked for
editing...........with the options to
1 Open as Read Only
2 Notify Me
3 Cancel

If I Open the file (or any Excel file) I get another Error Msg ----"The
instruction at 0x3005c5eb" referenced memory at "0x00000018". The memory
could not be written."
The OK button then closes Excel and the Cancel button opens Visual Basic
with code in C++

----------------------------
How do I regain access to the Excel application and why does the code I used
cause this?