I am getting "Run-time error '1004'. Application-defined or object-defined
error"

I have narrowed it down to the subroutine which builds excel objects and
does various formatting with the objects.

The program I have I pass a parameter as to which report I want to generate.
I have schedule tasks set up to run 2 jobs using the same executable but
with different parameters, but ALSO at the SAME time. The error only occurs
when these are running at the same. If I put the 2 job calls in a bat file
and run that - I get no errors.
Also, if I put a couple MsgBox in one of the subroutines and then take my
time click the Ok through the MsgBoxes, then both jobs run successfully.

So this is a problem running parallel excel process, and not if I run them
serially.

It is not feasible for us to run these serially because we generate many
reports, so one type would not even start for 5-10 or more minutes.

I have all the excel objects defined locally in each report type subroutine.
I do have some excelobjname.ActiveWindow, ActiveSheet, ActiveCell. Could
these really be using only one object in memory, even though I should have 2
objects in memory? Has anyone ever had problems similar? If so, any help
in resolution would be greatly appreciated.

Thanks Ahead of time

Dianna