Automation error object invoked has disconnected

Good Day Folks,

I have a very very annoying problem that is intermittent, in other words, my full code works 5 to 10 times, then it crashes with a automation error as above title. The circumstances are all the same every time, always crashing 70% into my progress bar, so I know something is wrong between 70% and 80%. Just a note: The VBA is run as a macro off another macro through a CALL. And in this code it is supposed to save and close the ARCHIVE.xlsb file (All it needs to do!). There is also multiple users using the archive file, but only 1 by 1 as I have another code handling the read-only status of the file, and as the error only happens when closing the file, I see no reason how multiple users can cause it to crash. And it works 99% percent of the time, only seldom crashes with an automation error.

My code (where it crashes)

Please Login or Register  to view this content.

My other untried alternative is putting in a On Error Resume - So it loops until it gets it right. But before I do that, I am asking the experts.

Thank You

JEDEMEYER1

Dave,

Between 70 & 80.

When activating the sheet. Remember - It only happens randomly - Not always.

Strange problem

Kind Regards,

JEDEMEYER1