Hi

I want to run a macro to Import Entire Text File to Single Cell.
I have Text Files in Multiple Folders, is there a way to Loop and get Data from all Text Files into One Sheet??

I have all text Files in 

"C:\Records\"

C:\Records\Folder1\TextFile1.txt
C:\Records\Folder2\TextFile2.txt
C:\Records\Folder3\TextFile3.txt
I want to get all text data Like (One Cell in a Row for One Text File)
Column A    --  Column B
File 1 Name -- File 1 Content
File 2 Name -- File 2 Content
File 3 Name -- File 3 Content
.
.
Is there any way to do this.. Please Help... Thank you...