ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   force excel to run in only one process excel.exe (https://www.excelbanter.com/excel-worksheet-functions/34369-force-excel-run-only-one-process-excel-exe.html)

Daniel

force excel to run in only one process excel.exe
 
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?




All times are GMT +1. The time now is 07:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com