Text count in word to text count in excel.

I need some help. Found this code that will count all the words in a document and give me a list of each word and the frequency. I need it to count the words on a spread sheet collum A for example and provide me same results on a new sheet. can someone help me convert the macro from reading a word document to reading a collum of text strings in Collum A of the sheet and providing the results in a row of words in Collum A of the new sheet with the frequency in collum B of the new sheeet? Here is the code.

Thanks
Chris

Please Login or Register  to view this content.

Here is the working version in Word and the output I want in excel. The excel file only has the 1st cell with a text field. I need it to do all the cells in collum A.

option to make it, please check attachment, press Run button

PS. Just in order not to screw up life of people keeping this place in order and as a gesture of respect on your part try to post code wrapped with special tags