Marco to Open all contents (.xlsm) in a folder and search each file for a word

So this macro will open all files in a folder:

Please Login or Register  to view this content.

but I don't know what you want the code to do WHEN/IF it finds troubleshoot anywhere. What are you wanting at that point?

Also is there a set number of sheets in each file, do they have only one sheet or multiple variable worksheets?

This will open all folders and search each cell in columns A:IV for the word troubleshoot however exactly what miektron said what do you want it to do when you find the word?

Please Login or Register  to view this content.

Does troubleshoot always fall in ONE particular cell?
Are there multiple sheets in each workbook?
What else can you tell us to help fine tune this thing?

Can you post a sample dataset to illustrate what you are wanting?

This checks all sheets in all files in a folder and puts the file names and cell addresses in a range.
The workbook with this code in it should not be in the same folder.

Please Login or Register  to view this content.

You can add the line to copy E23 into your workbook
Sorry, it checks the first column only.
You can change

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.

Ahh I must have been slow to respond, but mine is very similar to the above.

AllFilesOpen.xlsb

If it is solved can you mark it as such?