Cannot open 2 projects at the same time
 

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

Cannot open 2 projects at the same time
 

On Nov 11, 10:03 pm, Joseph of CSS in NJ <Joseph of CSS in
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.

Cannot open 2 projects at the same time
 

"dbKemp" wrote:

On Nov 11, 10:03 pm, Joseph of CSS in NJ <Joseph of CSS in
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.