I have built 16 projects that must combine totals in 1 project. I automated
the process with visual basic command keys, but I must open both projects at
the same time to do the data transfer. This is not a problem for 13 of the
16 projects. But 2 of the projects do not allow me to open the total project
while they are open. I get this message:
"Excel cannot complete this task with available resources. Choose less data
or close other applications."
Out of the 16 projects, they are not necessarily the largest. Other
projects contain more items, have more command keys programmed, and more
modules and user forms, yet they allow both projects to be opened at the same
time in the same open excel program.
What should I be looking for beside size to find the cause of this problem?
Thanks
Joe