rename open file after close for amount is in adjacent word in cell without add new file

Hi Mussala,
still fixing the code before closing
m.s.

Hi again,
ok I tested ,but there is problem !
when change amounts for some files and add or delete new files contains amounts the original code does not extract correct amounts in column D as in previous thread, will keep old amounts had ever extracted , I don't see any change in column D when change adding or deleting amounts for new file or old file within directory!

Hi Mussala,
the first thing the code does is delete the old values.
I added "debug steps" to the file.
Check the address where the new file will be written - last message.
By deleting cell F1, the "debug steps" will not be displayed.
m.s.

I'm not sure where get amounts from !!
may you compare amounts inside sheet with picture in the folder ?!

in the "Report" sheet there will be a list of what the code found.
It will be visible from which files it takes the numbers. (Original list).
The problem may be with other subdirectories that you do not want to have included in the report.
Or a different extension of the excel files. Or the number is in a different column.
m.s.

thanks
I've found my bad in lastrow for column D the amount is not the same amount for the file name.
I think we missed thing in previous thread should rename files first and you tell me

If the names are OK, we proceed to the second stage.

I suspect renaming files this is next step has missed!

in the sheet "Report" there will be new names of source files xls.
Check the correctness of the new name.
If it is OK, delete cell "G1" in sheet "Rename". Run the code again.
m.s.

I think last version you provided me works greatly and treat my problems.
many thanks.