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

On Nov 11, 10:03 pm, Joseph of CSS in NJ <Joseph of CSS in
N...@discussions.microsoft.com> wrote:
> 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

Do all projects have to be open through the entire process?

I had a similar problem with addins. Try opening the projects
separately, close all of the modules in the VBE and then save the
project. This will take less memory next time opened.

"dbKemp" wrote:

> On Nov 11, 10:03 pm, Joseph of CSS in NJ <Joseph of CSS in
> N...@discussions.microsoft.com> wrote:
> > 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
>
> Do all projects have to be open through the entire process?
>
> I had a similar problem with addins. Try opening the projects
> separately, close all of the modules in the VBE and then save the
> project. This will take less memory next time opened.

Only 2 projects need to be opened at once, but 3 of them will not open with
the totals project. The other 13 do open with it, and size doesn't seem to
be the issue. I did close all modules in VBE before saving. I will try
again.
Thank you.
>