+ Reply to Thread
Results 1 to 11 of 11

VBA to Count Words in MS Word Doc and List Down it in excel

  1. 06-17-2013, 08:14 AM #1
    harshadp
    harshadp is offline
    Registered User
    Join Date
    06-17-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2

    VBA to Count Words in MS Word Doc and List Down it in excel

    Hi Team,

    What could be done in case where i want to count words of a bunch of document in folder and also required output in excel file.

    I have something that i found from some where.

    Please Login or Register  to view this content.
    This macro runs fine in word givign error in excel
    Last edited by harshadp; 06-18-2013 at 11:41 AM. Reason: Use code tags as per forum rule 3.
    Reply With QuoteRegister To Reply
  2. 06-18-2013, 09:22 AM #2
    Tinbendr
    Tinbendr is offline
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: VBA to Count Words in MS Word Doc and List Down it in excel

    Welcome to the board. 

    Please Login or Register  to view this content.
    David
    (*) Reputation points appreciated.
    Reply With QuoteRegister To Reply
  3. 06-18-2013, 09:56 AM #3
    harshadp
    harshadp is offline
    Registered User
    Join Date
    06-17-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: VBA to Count Words in MS Word Doc and List Down it in excel

    Thanks Tinbendr for such quick response. Its working great.
    Reply With QuoteRegister To Reply
  4. 07-27-2017, 02:55 AM #4
    vinayak87
    vinayak87 is offline
    Registered User
    Join Date
    07-27-2017
    Location
    India
    MS-Off Ver
    2010
    Posts
    4

    Re: VBA to Count Words in MS Word Doc and List Down it in excel

    Thanks Tinbendr.

    The path needs to provided in code, but could you please check if user can select a folder as per requirement?

    Thanks in advance.
    Reply With QuoteRegister To Reply
  5. 07-27-2017, 05:04 AM #5
    vinayak87
    vinayak87 is offline
    Registered User
    Join Date
    07-27-2017
    Location
    India
    MS-Off Ver
    2010
    Posts
    4

    Re: VBA to Count Words in MS Word Doc and List Down it in excel

    Thanks Tinbendr.

    If a folder contains 90 word files, then the result appears only for 60 files.

    Could you please suggest?

    Thanks in advance.
    Reply With QuoteRegister To Reply
  6. 07-27-2017, 06:36 AM #6
    Tinbendr
    Tinbendr is offline
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: VBA to Count Words in MS Word Doc and List Down it in excel

    You really should start a new thread and reference this one.

    However, add this:
    Please Login or Register  to view this content.
    Change this 
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.
    Probably would be a good idea to test for a empty folder in case the user cancels.

    Sorry, but I don't really know why it's only processing 60 of 90 files.
    Reply With QuoteRegister To Reply
  7. 07-27-2017, 08:24 AM #7
    vinayak87
    vinayak87 is offline
    Registered User
    Join Date
    07-27-2017
    Location
    India
    MS-Off Ver
    2010
    Posts
    4

    Re: VBA to Count Words in MS Word Doc and List Down it in excel

    Thanks Tinbendr.
    Reply With QuoteRegister To Reply
  8. 09-15-2017, 03:17 AM #8
    sudarbharath
    sudarbharath is offline
    Registered User
    Join Date
    09-14-2017
    Location
    india
    MS-Off Ver
    2013
    Posts
    2

    Re: VBA to Count Words in MS Word Doc and List Down it in excel

    Hi Tinbendr ,

    Macro working great. can i get no of pages in the word document & No of characters used in the document?

    Regards,
    Reply With QuoteRegister To Reply
  9. 09-15-2017, 11:06 AM #9
    Tinbendr
    Tinbendr is offline
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: VBA to Count Words in MS Word Doc and List Down it in excel

    Search is your friend
    Reply With QuoteRegister To Reply
  10. 09-15-2017, 02:48 PM #10
    sudarbharath
    sudarbharath is offline
    Registered User
    Join Date
    09-14-2017
    Location
    india
    MS-Off Ver
    2013
    Posts
    2

    Re: VBA to Count Words in MS Word Doc and List Down it in excel

    Hello friend,

    can you please give code page count...
    Reply With QuoteRegister To Reply
  11. 09-15-2017, 05:17 PM #11
    protonLeah
    protonLeah is offline
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,598

    Re: VBA to Count Words in MS Word Doc and List Down it in excel

    sudarbharath,
    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
    Ben Van Johnson
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1