Error 1004 Application-defined or object-defined error on Workbook.Close?

Hey all,

I have a tool that iterates through a file and saves all the new scripts (pretend I have 100 characters which all have scripts of 3 - 110 lines) separately with the name of the character. For some reason I get an Error 1004 on ActiveWorkbook.Close on one of the characters scripts. The only difference I can tell between the working scripts and this one failed one, is that the failed script has more than 100 lines. I have tried DoEvents, I have tried turning savechanges to false but still the same error. Help me Obi-Wan Kenobi.

Bonus points if you can figure out why I get an error when the iteration is completed successfully...

Please Login or Register  to view this content.

Hi there,

If the code works successfully in the majority of cases, then the problem is almost certainly related to the data you are processing, but unfortunately you give us no idea of what data are involved.

Can you post a copy of your workbook so that we have a better chance of determining what is/isn't happening?

Regards,

Greg M

Hey Greg,

Unfortunately I can't, when I redact the data it fixes the problem. So clearly it's an issue with the data, unfortunately it looks identical to the working data so I am totally stumped :/