Application.quit

[cush]

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++

 

[Tom Ogilvy]

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

Then reboot.

 

[Vergel Adriano]

Open the Windows Task Manager (press CTRL+SHIFT+ESC). Go to the Processes
tab and find EXCEL.EXE. Select the EXCEL.EXE process then click on the "End
Process" button. Terminate all EXCEL.EXE processes that you see.

If that does not work or if you don't see an EXCEL process in the task
manager, try to reboot your computer.

 

[cush]

Tom,

I'm confused about the location of this temp folder.
I have a Temp folder located at

Docs and Settings\Admin\Local Settings\Temp
with approx 75 folders therein ... among them
is a folder labeled Excel8.0
I'm hesitant in deleting this entire Temp folder as I am over my
head here and I don't want to lose something that is vital.

Can you be specific regarding the location of the temp
folder you are referencing.
thanks

 

[Tom Ogilvy]

That would be the one. I don't think you need to delete the sub
directories, only the files in the temp folder itself. That said, it has
always been my impression that if it is in the temp folder and not in use, it
can be deleted, including subdirectories.

If you try to delete everything at once, you may get a message that a
specific file can not be deleted - you will need to work around these.

 

[Vergel Adriano]

If you don't feel comfortable with deleting files in the Temp folder, maybe
just move them to a different folder. If for whatever reason, you need to
get the files back in the Temp folder, you can just move them back over.

 

[Curt]

I have used the same event without the Application.quit with my efforts.
Works fine for my use. closes and exits same as quiting.