Reduce processing time for processing multiple excel sheets

I have a number of excel sheets which I need to assess.
Idea was to place all the excel sheets in one location and process them simultaneously
So, I would place the excel sheets in folder "Show" and then would run the macro to add the word "inplace" if the column H was containing some data, and then it would save the excel sheet.



I have the following code which works but takes about 98 seconds to process ( too long) .. Need help to reduce the processing time or to develop a new logic which can reduce the time to process.

Please Login or Register  to view this content.