Modify Code to Run across multiple worksheets in directory

I have macro that deletes text string when found in worksheet. I need to modify code to be able to run across hundreds of worksheets in one directory/folder. Thanks in advance for help. Below is code that is working for worksheet.

Please Login or Register  to view this content.

Moderator's Note: As per Forum Rule #3, please use code tags…Thanks.

A worksheet is a single page or sheet in a spreadsheet program such as Excel.
A workbook is a spreadsheet file. By default, each workbook in Excel contains three pages or worksheets.

tdm,

Here's one way...

Please Login or Register  to view this content.