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)
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
Bookmarks