Process all Excel files in a folder: open, modify, save

[Gintaras]

In one folder, I have 500 EXCEL files.

All the EXCEL files have the same structure (same fields, same design).

I would like to make some changes to all of the EXCEL files (add a field, change a formula).

The changes will be the same for all the 500 EXCEL files.

My question is:

Is the software capable of opening the first EXCEL file, making the changes, saving the file.
Then it opens the second EXCEL file in the folder, makes the changes, saves the file.
Then it opens the third EXCEL file in the folder, makes the changes, saves the file.
And continues to modify all the 500 files in the folder without any user intervention (Like a batch process) ?