Slow loading after open many excel with batch

[alee001]

Hello,
I am a novice for batch script, I don't know why slow loading (show on state bar calculating) after open many excel files with my bat file (Open system.bat) as following. But normal fast if independent open them. anyone help me? Thanks.

@echo off
start "C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE" "C:\Users\alee\Documents\My Documents\My system\System ver3.xlsb"
start "C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE" "C:\Users\alee\Documents\My Documents\My system\System ver3_02.xlsb"
start "C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE" "C:\Users\alee\Documents\My Documents\My system\System ver3_03.xlsb"
start "C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE" "C:\Users\alee\Documents\My Documents\My system\System ver3_04.xlsb"
start "C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE" "C:\Users\alee\Documents\My Documents\My system\System ver3_05.xlsb"
start "C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE" "C:\Users\alee\Documents\My Documents\My system\System ver3_06.xlsb"
start "C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE" "C:\Users\alee\Documents\My Documents\My system\System ver3_07.xlsb"
start "C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE" "C:\Users\alee\Documents\My Documents\My system\System ver3_08.xlsb"
start "C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE" "C:\Users\alee\Documents\My Documents\My system\System ver3_09.xlsb"
start "C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE" "C:\Users\alee\Documents\My Documents\My system\System ver3_10.xlsb"
start "C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE" "C:\Users\alee\Documents\My Documents\My system\System ver3_11.xlsb"
start "C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE" "C:\Users\alee\Documents\My Documents\My system\System ver3_12.xlsb"
start "C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE" "C:\Users\alee\Documents\My Documents\My system\System ver3_13.xlsb"
start "C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE" "C:\Users\alee\Documents\My Documents\My system\System ver3_14.xlsb"
start "C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE" "C:\Users\alee\Documents\My Documents\My system\System ver3_15.xlsb"
start "C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE" "C:\Users\alee\Documents\My Documents\My system\System ver3_16.xlsb"
start "C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE" "C:\Users\alee\Documents\My Documents\My system\System ver3_17.xlsb"
start "C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE" "C:\Users\alee\Documents\My Documents\My system\System ver3_18.xlsb"
start "C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE" "C:\Users\alee\Documents\My Documents\My system\System ver3_19.xlsb"
start "C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE" "C:\Users\alee\Documents\My Documents\My system\System ver3_20.xlsb"
exit

 

[offthelip]

I suspect that your problem is because you are starting multiple versions of EXCEL instead of opening multiple files in a singe instance of excel. Have a look on task manager and see how much memory is being taken up by excel., check it after running only one or two lines of your script. I think you should open one instance of excel which opens an excel file with a macro which runs on open, to open all of the files you need and then closes itself down.

 

[alee001]

I suspect that your problem is because you are starting multiple versions of EXCEL instead of opening multiple files in a singe instance of excel. Have a look on task manager and see how much memory is being taken up by excel., check it after running only one or two lines of your script. I think you should open one instance of excel which opens an excel file with a macro which runs on open, to open all of the files you need and then closes itself down.

Thanks for your reply, I must open them with each independent Excel in order to run VBA. I had tried to run several open file, but I don't know why the CPU is still loading increase? But no problem open with Alt+Excel.

PS Windows 11 Pro, Excel 2021, i9-11900K

 

[alee001]

The problem is that if you manually open each Excel file, it will only automatically calculate the current window, but if you use batch to open the Excel file continuously, it will continue to simultaneously calculate the opened files, which will cause the CPU to be overloaded. Finally, the error will flash. Retreat, how can I solve it?