force excel to run in only one process excel.exe

[Daniel]

force excel to run in only one process excel.exe, excel seems to want to
make multiple excel.exe loaded into memory which causes mysheet.copy to fail
so i have to close out the xls, kill all running excel.exe, then run the xls
again and the macro works. i only have to do this when i am actively
debugging a lot. if i just run my macro w/o opening the vba debugger, i can
run it as much as i want, but if i run with break points it crashes a lot
because of multiple excel.exe loaded into memory. perhaps there is a way i
can force excel to only load one excel.exe?

 

[Jim Cone]

Daniel,

Are you using Automation to create an instance of Excel?

Jim Cone
San Francisco, USA

force excel to run in only one process excel.exe, excel seems to want to
make multiple excel.exe loaded into memory which causes mysheet.copy to fail
so i have to close out the xls, kill all running excel.exe, then run the xls
again and the macro works. i only have to do this when i am actively
debugging a lot. if i just run my macro w/o opening the vba debugger, i can
run it as much as i want, but if i run with break points it crashes a lot
because of multiple excel.exe loaded into memory. perhaps there is a way i
can force excel to only load one excel.exe?

 

[Daniel]

i dont know im using alt-f11

 

[Jim Cone]

Daniel,
Well, maybe that means you are not using automation.
To get any help, you will have to post your code.
Jim Cone
San Francisco, USA


i dont know im using alt-f11