Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jan 2007
    Location
    Massachusetts, USA
    Posts
    272
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Macro to spellcheck folder full of word documents (MS Word 2003)

    Hello,

    I would like to be able to create a macro (if possible) that will generate a list of misspelled words and missing periods, that exist in a collection of word documents. All of the word documents are in the same folder, so I would like to be able to have the macro point to that folder and search for misspelled words and missing periods on a global level.

    I appreciate any assistance I can get with the creation of this macro.

    Regards,

    Jim

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Macro to spellcheck folder full of word documents (MS Word 2003)

    The macro in the attached text file will prompt the user to select a folder, then loop through the Word documents in the folder and produce a list of spelling errors in a new document. Detecting missing periods will be more difficult, I think.
    Attached Files Attached Files

  3. #3
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro to spellcheck folder full of word docume

    Get rid of the space between the Highlighted with and application.file....

    With Application.FileDialog(msoFileDialogFolderPicker) should be on one line.

  4. #4
    3 Star Lounger
    Join Date
    Jan 2007
    Location
    Massachusetts, USA
    Posts
    272
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Macro to spellcheck folder full of word docume

    Thanks to Hans and mbarron for the postings. This macro is really great and has already save me a lot of time. Thanks again!!!

    Jim

  5. #5
    3 Star Lounger
    Join Date
    Jan 2007
    Location
    Massachusetts, USA
    Posts
    272
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Macro to spellcheck folder full of word documents (MS Word 2003)

    Screenshot shrunk by HansV - don't post such bizarrely large pictures PLEASE!

    Hello Hans,

    Thanks for the quick reply. I created the new macro, but I am getting an error message.
    I have attached a screen shot of the error message.
    Could this error involve the Normal.dot file?

    Thanks,

    Jim
    Attached Images Attached Images
    • File Type: gif x.gif (26.5 KB, 3 views)

Posting Permissions

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