Run-time error '1004' running to excel objects at once

D

Dianna Braden

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert multiple objects at once ? 3
"Run-time error '1004' 5
VSTO C# add in Outlook.Appointment error 0
Run-time 1004 error 0
Shell command produces a "Run-time error '5': Invalid procedure call or argumen 0
Run-time error 1004 8
Run-time error 1004 3
VBA Assigning cell value to variable giving runtime error 3

Top