Louise Harnby | Fiction Editor & Proofreader
  • Home
  • Resource library
  • Services
  • Courses
  • Books
  • Podcast
  • Blog
  • Training login
  • Contact
The Editing Blog: for Editors, Proofreaders and Writers

FOR EDITORS, PROOFREADERS AND WRITERS

A nifty little proofreading and editing macro: ProperNounAlyse

8/10/2015

9 Comments

 
If you proofread or copyedit fiction or non-fiction, or you're self-editing your own books, here's a macro that will highlight potential inconsistencies in proper-noun usage.
Proofreading and editing macro
Picture
I've been meaning to review some of my favourite proofreading macros for a while now and ProperNounAlyse deserves its first place in the queue (only because it performed so brilliantly on a recent proofreading project!).

ProperNounAlyse is just one tool among many, of course. Those of us who use macros on a regular basis have a whole suite of them that we run during the process of a proofread or a copy-edit.

ProperNounAlyse was created by my colleague Paul Beverley, and it’s just one of a huge number of macros available in his free book, Computer Tools for Editors (available on his website at Archive Publications).

I've written this post for the person who doesn't use macros and is nervous about trying. I think it’s such a shame when a fear of tech leads to lost opportunities for those who want to increase productivity (which is great for the editorial pro) and improve quality (which is great for the client).

Why bother? Three reasons
  1. ProperNounAlyse is easy to install, even for those with absolutely no technical savvy, and quick to run.
  2. It’s great for picking up inconsistencies in proper nouns (even double words, e.g. Louise Harnby vs Louise Hornby) while allowing you to maintain complete control over the text. This is because it’s not changing anything in the document you’re working on; rather, it works through the text in a Word document and provides a summary analysis of what it finds. That leaves you free to identify what needs sorting and what needs leaving well enough alone. I find it particularly useful when I'm proofreading fiction with lots of characters whose names may inadvertently end up being spelled slightly differently. A writer can become so immersed in the story they’re building that these kinds of slippages are easily missed. And even the best professional proofreader is only human, so using a little bit of simple tech to complement the eyes and brain makes good sense.
  3. While you’ll find it useful for paid work, it’s also a sharp little tool for providing insight into the state of a file you’re being asked to quote for. One of my colleagues routinely runs this in conjunction with another couple of macros in order to get an overview of the author’s consistency. I've taken a leaf out of her book and started using ProperNounAlyse in this way too.

Installing ProperNounAlyse
Go to Paul’s website and download Computer Tools for Editors.

Save the zipped folder to your computer and extract three files: One is an overview of the macros – what they are, what they do, how to store them and so on – plus all the programs themselves; another contains just the actual macro programs; and the final file is a style sheet. The file you need to open in Word is “The Macros”.

Use Word’s navigation menu (or Ctrl F on a PC) to open the Find function. Type “Sub ProperNounAlyse” into the search field and hit Return. That will take you to the start of the relevant script.

Select and copy the script from “Sub ProperNounAlyse()” down to “End Sub”. Paul’s helped us out by highlighting the name of each new macro.

Still with Word open, open the “View” tab and click on the “Macros” icon on the ribbon.
Picture
This will open up a new window.

If you don’t have any macros already loaded:
  • To get you going, create a test macro that you can delete later.
  • First, make sure the Normal.dotm template is showing in the "Macros in:” box.
  • Type TEST into the “Macro name:” box.
  • Click on “Create”. Your TEST macro will now show up. From now on, it’ll be easy as pie to add additional macros.
Picture
If you have macros loaded (your TEST macro or any other):
  • Click on “Edit”.
Picture
This will open up another window:
Picture
  • If necessary, use the scroll bar to take you to the bottom of the text.
  • Paste the ProperNounAlyse script at the end, under “End Sub”.
  • Close the window using the X in the top right-hand corner.
The installation is now complete.

Running ProperNounAlyse
  • Open the Word file you want to analyse.
  • Click the “View” tab.
  • Click the “Macros” icon on the ribbon.
  • Select "ProperNounAlyse" from the list.
  • Click “Run”.
Picture
A fictive sample
Below is a simple word list of proper nouns with lots of inconsistencies – differences in accent use, apostrophe use and spelling.
Picture
I run ProperNounAlyse on the document. It analyses the text and then creates a new Word file with the following results:
Picture
Picture
I’m provided with an at-a-glance summary of potential problems that I need to check. It may be that the differences identified are not mistakes, but I know what to look for.

“I don’t need to use techie tools … my eyes are good enough”
Macros don’t get tired. Macros don’t get distracted. I don’t believe any proofreader who claims they can do as good a job with their eyes alone as they can do with their eyes and some electronic assistance. It’s a case of using these kinds of tools as well as, not instead of, the eyes and brain.

I could have relied on my eyes to find all of the above problems, and in a small file I would hope to have hit the mark 100%. But if I’d been working on 100,000 words of text, and there were twenty key characters, a plethora of grammatical glitches, two major plot holes, numerous layout problems, and a mixture of hundreds of other inconsistencies regarding hyphenation, capitalization, punctuation and regional spelling variation, there would have been a lot of problems to solve; I want to utilize every tool available to help me do that.

Yes, my eyes and brain are two of those tools. But using macros like ProperNounAlyse and others (PerfectIt, for example, just because it’s another favourite!) speeds me up, pure and simple, and massively reduces the chance of a miss.

I ran ProperNounAlyse on a recent fiction proofread for an independent author who is a phenomenally good writer – great plot, excellent pacing, engaging characters. But he was so busy crafting the 95,000 words it took to build a fantastic story that he’d introduced a lot of proper-noun inconsistencies. That’s fine – it’s not his job to deal with these; it’s mine. It took me minutes, rather than hours, to locate them and deal with them. And I know I found them – every one of them.
 
What will the client remember?
If you’re still reluctant to try out ProperNounAlyse (or any other editorial tool for that matter), consider this: What will the client remember? The three hundred mistakes that you spotted or the three howlers you missed?

​When it comes to proper nouns, especially in large volumes of character-based editorial work, it’s too easy to miss a discrepancy. And character names stand out to readers. Taking just a few minutes to run a simple-to-use macro might determine whether your client thinks your work was pretty good or outstanding.

Which of those is likely to gain you a repeat booking or a referral to another potential client?
Louise Harnby is a line editor, copyeditor and proofreader who specializes in working with crime, mystery, suspense and thriller writers.

She is an Advanced Professional Member of the Chartered Institute of Editing and Proofreading (CIEP), a member of ACES, a Partner Member of The Alliance of Independent Authors (ALLi), and co-hosts The Editing Podcast.

Visit her business website at Louise Harnby | Fiction Editor & Proofreader, say hello on Twitter at @LouiseHarnby, connect via Facebook and LinkedIn, and check out her books and courses.
9 Comments
Hilary Cadman
9/10/2015 04:08:03 am

Thanks Louise, I haven't tried this macro before, but I can see how useful it would be

Reply
Buki
19/1/2016 10:21:13 am

Thank you very much! I installed it so easily, I'm wowed. Thank you Ms. Harnby, thank you Mr. Beverly.

Reply
Angela Wingfield link
11/8/2017 02:18:44 pm

This sounds great, Louise. Can the macro be used on a PDF, the usual format in which I receive text for proofreading?

Reply
Kristi Hein link
24/10/2017 06:25:09 pm

I followed your instructions carefully and when I tried to run the macro, I got this Microsoft Visual Basic message: "Compile error: Wrong number of arguments or invalid property assignment."
Defeated, I return to the billable work I should be doing.

Reply
Louise Harnby
24/10/2017 07:14:39 pm

Sorry to hear it's not worked for you, Kristi. I'm sure Paul will be more than happy to help if you think this is worth pursuing for the sake of efficiency in the longer term. He's incredibly generous with his time and always willing to find solutions to people's problems.

I wrote this post back in 2015. I wonder if something's been tweaked since then. I've certainly used it many times this year but I uploaded it two years ago so I'm prepared to accept that the instructions may have changed.

Best wishes,
Louise

Reply
Cindy Reeh link
28/3/2018 06:29:46 pm

I've known about this macro but hadn't gotten around to trying it. I just followed your instructions and ran the macro successfully. I'm convinced! I'll be using it from now on. Thank you.

Reply
Louise Harnby
28/3/2018 11:28:04 pm

Glad you like it, Cindy!

Reply
Vanessa Flaxman
25/7/2019 02:52:22 pm

Thank you so much Louise, this is brilliant! I'm still fairly new to proofreading and editing, and your site has been the most invaluable help. I've been avoiding macros as thought they would be beyond my tech abilities, but this was so simple to set up and wow - what a help this one is going to be! I'm off to read about all the others in his book now, I can see macros are going to be a new fave thing of mine! ;) Thanks again for all your incredible advice, you are truly an amazing help to those of us wanting to follow in your footsteps and become successful proofreaders and editors! :)

Reply
Louise Harnby
26/7/2019 10:07:32 pm

So glad you've discovered and love macros, Vanessa! Season 2, Episode 5 of The Editing Podcast is all about our 10 favourite macros that editors and self-editing writers will love!

Reply



Leave a Reply.

    BLOG ALERTS

    If you'd like me to email you when a new blog post is available, sign up for blog alerts!
    Proofreading stamps
    ALERT ME!

    WHAT DO YOU NEED?

    • Training courses
    • ​Books and guides
    • Editor resources
    • Author resources
    • ​Monthly newsletter
    Picture
    SIGN ME UP

    PDF MARKUP

    Proofreading stamps

    AUTHOR RESOURCES

    Proofreading stamps

    EDITOR RESOURCES

    Proofreading stamps

    BOOKS FOR EDITORS AND WRITERS

    Picture
    Picture
    Picture
    Picture
    MORE BOOKS

    TRAINING COURSES FOR EDITORS

    Picture
    Picture
    Picture
    Blogging for Business Growth course
    MORE COURSES

    TESTIMONIALS


    Dare Rogers

    'Louise uses her expertise to hone a story until it's razor sharp, while still allowing the author’s voice to remain dominant.'

    Jeff Carson

    'I wholeheartedly recommend her services ... Just don’t hire her when I need her.'

    J B Turner

    'Sincere thanks for a beautiful and elegant piece of work. First class.'

    Ayshe Gemedzhy

    'What makes her stand out and shine is her ability to immerse herself in your story.'

    Salt Publishing

    'A million thanks – your mark-up is perfect, as always.'
    TESTIMONIALS

    CATEGORIES

    All
    Around The World
    Audio Books
    Author Chat
    Author Interviews
    Author Platform
    Author Resources
    Blogging
    Book Marketing
    Books
    Branding
    Business Tips
    Choosing An Editor
    Client Talk
    Conscious Language
    Core Editorial Skills
    Crime Writing
    Design And Layout
    Dialogue
    Editing
    Editorial Tips
    Editorial Tools
    Editors On The Blog
    Erotica
    Fiction
    Fiction Editing
    Freelancing
    Free Stuff
    Getting Noticed
    Getting Work
    Grammar Links
    Guest Writers
    Indexing
    Indie Authors
    Lean Writing
    Line Craft
    Link Of The Week
    Macro Chat
    Marketing Tips
    Money Talk
    Mood And Rhythm
    More Macros And Add Ins
    Networking
    Online Courses
    PDF Markup
    Podcasting
    POV
    Proofreading
    Proofreading Marks
    Publishing
    Punctuation
    Q&A With Louise
    Resources
    Roundups
    Self Editing
    Self Publishing Authors
    Sentence Editing
    Showing And Telling
    Software
    Stamps
    Starting Out
    Story Craft
    The Editing Podcast
    Training
    Types Of Editing
    Using Word
    Website Tips
    Work Choices
    Working Onscreen
    Working Smart
    Writer Resources
    Writing
    Writing Tips
    Writing Tools

    ARCHIVES

    March 2023
    January 2023
    December 2022
    November 2022
    October 2022
    September 2022
    August 2022
    July 2022
    June 2022
    May 2022
    April 2022
    March 2022
    February 2022
    January 2022
    December 2021
    November 2021
    October 2021
    September 2021
    August 2021
    July 2021
    June 2021
    May 2021
    April 2021
    March 2021
    February 2021
    January 2021
    December 2020
    November 2020
    October 2020
    September 2020
    August 2020
    July 2020
    June 2020
    May 2020
    April 2020
    March 2020
    February 2020
    January 2020
    December 2019
    November 2019
    October 2019
    September 2019
    August 2019
    July 2019
    June 2019
    May 2019
    April 2019
    March 2019
    February 2019
    January 2019
    December 2018
    November 2018
    October 2018
    September 2018
    August 2018
    July 2018
    June 2018
    May 2018
    April 2018
    March 2018
    February 2018
    January 2018
    December 2017
    November 2017
    October 2017
    September 2017
    August 2017
    July 2017
    June 2017
    May 2017
    April 2017
    March 2017
    February 2017
    January 2017
    December 2016
    November 2016
    October 2016
    September 2016
    June 2016
    May 2016
    April 2016
    March 2016
    February 2016
    January 2016
    December 2015
    November 2015
    October 2015
    September 2015
    July 2015
    June 2015
    May 2015
    March 2015
    February 2015
    January 2015
    November 2014
    October 2014
    September 2014
    August 2014
    July 2014
    June 2014
    March 2014
    January 2014
    November 2013
    October 2013
    September 2013
    August 2013
    June 2013
    February 2013
    January 2013
    November 2012
    October 2012
    September 2012
    August 2012
    July 2012
    June 2012
    May 2012
    April 2012
    March 2012
    February 2012
    January 2012
    December 2011

    RSS Feed

Alliance of Independent Authors
Picture
Picture
CIEP Advanced Professional Member
The Publishing Training Centre
INFO ABOUT ME
Privacy policy
Terms and conditions
Contact form
Code of practice
Qualifications
​Portfolio ​ 
​Bio page
Louise's fiction
About Louise
INFO FOR INDIE AUTHORS
Editorial services
Contact form
Can you expect perfection?
Books and guides
Transform Your Fiction series
Free resources
​
Order form for books
Testimonials
Self-editing book

Want to sign up to my monthly newsletter, The Editorial Letter? 
INFO FOR EDITORS
Training courses​
Books and guides
​​Business Skills for Editors series
Transform Your Fiction series
Free resources
1:1 business consultations
Order books and courses
​The Editing Podcast
​The Editing Blog