I have a strange problem with Excel. I have a few users
creating macro's that aren't doing anything out of the
ordinary. The layman's terms of the process a they
will go to a path and open a file, copy it in the
template, close the file, do some formatting to the
template, save the template as something else and go on
to the next one. Some will have 5 or 6 files to open.
Some will only have one. Other will have quite a few.

They run them one time...and Excel bombs with a basic
error. Run it again right away and it works fine. Run
it and it fails after creating a few reports, or
sometimes it will run without a problem at all. It is
completely random. This is not just local to one
machine...any machine that you attempt to run this macro
from results in the same random problems. So my question
is: what could cause such instability in Excel?

1) We are running Office XP with both service packs.
2) Windows XP with SP and all critical updates