How to open a Word.doc using VBA and count the words in the word.doc?

**eijoah** · 10-31-2007, 11:30 PM

I have problem writing a code to open a word.doc and count the different number of words in the doc. my code is as follows. Can anyone tell me what is the prob?

Please Login or Register  to view this content.

**rylo** · 11-01-2007, 07:39 PM

Hi

See how this goes.

Please Login or Register  to view this content.

rylo

**eijoah** · 11-02-2007, 02:19 AM

Thnks for your help. It worked. Do you mind if u can help me with how can i make all the word in the word.doc file to be tabulated so as to able to know the frequency of evry repeated words? thnks if anyone can help..

**rylo** · 11-04-2007, 09:52 PM

Hi

Try this

Please Login or Register  to view this content.

Something I found out is that the wordcount used this way will include all the punctuation and paragraph marks. It doesn't bring back the same count as the word count from the document itself.

The above script will therefore show some "blank" characters which may be paragraph marks, tabs etc.

HTH

rylo