02-24-2009, 05:00 PM
Look in Task Manager. There should be a hidden EXCEL.exe process that locked the file. End it.
I don't have this problem with your code. If EXCEL does not disappear from the task manager when the macro ends, try to add this at the end:
err+
es.ws.Application.Quit
I don't have this problem with your code. If EXCEL does not disappear from the task manager when the macro ends, try to add this at the end:
err+
es.ws.Application.Quit
