How to copy whole data from MS word into Excel Cell

[satish78]

Hi

Found few references on Mrexcel but are not relevant to my query.

I have a huge list of documents with file types like ms word(.doc, .docx, rft etc), pdf, .txt

Trying to loop a list of above file type location paths from excel sheet2 and extract whole data from msword document, pdf and txt files into sheet1 single cell and wrap it automatically to avoid enlarge cells.
Can anyone provide the VBA code which loops list of location paths from sheet2 ?. and input data Sheet1.

Thanks
Satish