Excel file damaged again for no reason? !

Add that I have not installed any plug-ins or third-party programs on Office or Excel.

There is no problem when all files is used in Excel 2010 on the old computer Win7.

Thanks for providing me with the additional information below and above for my clarification.

So, it seems that the issue might be related to the script or the speed at which the files are being opened.

When using a script or automated process to open multiple Excel files simultaneously, it's possible that the files are not being given enough time to fully load and initialize before the next file is opened. This can sometimes result in crashes or issues with certain files.

To address this, you can try modifying the script or adjusting the timing between opening each file. By introducing a delay or a pause between opening files, you give Excel more time to process and load each file properly. This can help mitigate any potential conflicts that may arise from opening multiple files rapidly.

Additionally, you mentioned that there were no issues when manually opening the files one by one. This would further support the idea that the speed of the script or automated process may be a contributing factor to the problem. Taking a more sequential approach to opening the files could help ensure that each file has enough time to load successfully before proceeding to the next one.

Also, the performance of Excel can vary between different versions and configurations. Since you mentioned that there were no issues when using Excel 2010 on a different computer, it's possible that there may be compatibility or system-specific factors at play. If possible, you could also try running the script on a different computer with Excel 2021 to see if the issue persists.

I hope these suggestions help you in troubleshooting the issue further.

Thank you for your attention, I have been looking for a way to make the script open the delay between Excel to confirm this problem, but no suitable code is available. Do you have any suggestions for this?

As per my research,

The timeout command waits for a specified number of seconds before proceeding with the script execution.

Here's how you can modify your script to include a delay between opening each Excel file:

@echo off

set "excelPath=C:\Path\to\Excel.exe"
set "files=C:\Path\to\Files\file1.xlsx C:\Path\to\Files\file2.xlsx C:\Path\to\Files\file3.xlsx"

for %%F in (%files%) do (
    start "" "%excelPath%" "%%F"
    timeout /t 5 >nul  # Adjust the delay time (in seconds) as needed
)

In the above script, replace the excelPath variable with the path to your Excel executable file (e.g., excelPath="C:\Program Files\Microsoft Office\Office\EXCEL.EXE"), and the files variable with the paths of the Excel files you want to open.

The timeout /t 5 command introduces a 5-second delay between opening each Excel file. You can adjust the delay time as needed by changing the value after /t. The >nul part is used to suppress the output of the timeout command.

This is mostly from online research. I'd say try experimenting with this code.

And let me know if you made it work. :D

I have also tried timeout, sleep, waitfor and other commands in the past, but they cannot be executed or have no effect. (not looping is code between opening files)