• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need Help With Word Count


Greetings Experts,

I have a very interesting challenge for everyone today. I have a very big Word document and there are attached objects(Not links).

What I am trying to do is to create a VBA subroutine flexible enough to be able to include counting the words present in these attachments. In the end, it is best to show a message box with the accumulated number of all the words in the Word document inclusive of all the words present in the attachments in the document.

It also needs to be "smart" enough to know what documents it can count from. For example, it would skip any MP4 embedded objects or images but read pdf, xlxs, etc.

Is this possible? Any help is much appreciated! :)


Excel Ninja
Probably no. PDF for one can be image based or encoded text. And I'm not certain how Word treats embedded objects.

But since this site/forum is focused on MS Excel. You may find more expert help asking in MS Word specific VBA forum.