Excel Macro to enable find and replace in all files in a drive

[sujayquery]

We have one scenario with a customer. The have around 100-word documents, 200 excel sheets, 10 PDFs, around 50 text documents and not all these at one place (located at different places, drives). They want to replace few words in all these documents with newer words. How can we make search and replace easy in such a situation using Excel Macro? Any info on this will be really helpful.

 

[vletm]

sujayquery
Why did You open a new Ask an Excel Question,
if You're looking for VBA Macros solution?
Are You sure that You read well Chandoo.org Forum Rules before posting the 1st thread?
>> moved this thread to VBA Macros

 

[sujayquery]

sujayquery
Why did You open a new Ask an Excel Question,
if You're looking for VBA Macros solution?
Are You sure that You read well Chandoo.org Forum Rules before posting the 1st thread?
>> moved this thread to VBA Macros

I could not find the solution that's why I posted just in case anybody have any answer.