Copy data from wordpad to Excel Sheet-vba code required.

I have 1000+ of files (different format than .txt/.doc files).
I need to open these files only in wordpad (so that I can able to view the content).
I would like to extract some information from these files after moving it to an excel sheet.
So for this purpose I need to import whole data from "wordpad" files to excel.

I can able to open my file in wordpad but unable to copy & paste in the required excel sheet.
Please send me the vba code.

Please help me.