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

"Gary" wrote in message
...
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

If you were to tell us

1) What the errors actually are
2) What code is being called at the time

We might be able to help

It sounds as if you are getting run time errors opening
the files which could be because they are locked by
someone else editing them or some other process which
exclusively locks them but without further details ....

Keith