View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
JMay JMay is offline
external usenet poster
 
Posts: 468
Default Device I/O Error

Thanks JLatham;
Your logic makes total sense. I removed the Unload me (line) and things
seem to be working better.
Jim

"JLatham" wrote:

Generally, "Device I/O Error" is hardware related. You might give strong
consideration to making sure you have a good backup strategy in place for
whatever drive you are using to save those files on.

BTW: You shouldn't even need the "Unload Me" statement in your sub ... it's
going to be unloaded when the ThisWorkbook.Close statement executes.

The Unload Me may even be confusing things (haven't tested it) because
Unload means to take it out of memory, which would, in theory at least,
remove the code in it also.

"JMay" wrote:

After stepping thru my code I'm getting the aboce message.
What does this usually mean? Any hints would be helpful.