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

Dispelling the Macro Man myth

28/11/2017

0 Comments

 
The latest from the Macro Chat column by editor Paul Beverley ... In this post, Paul shares the story of his programming and editing journey. Talking of which, his latest videos on wildcard find-and-replace techniques are gems: Wildcarding techniques 1; Wildcarding techniques 2; Wildcarding techniques 3.
Dispelling the Macro Man myth
Some people are surprised to discover that I have a bank of over 500 macros for editors and proofreaders, and I’ve recently had several encouraging comments about my ‘amazing programming skills’, but in my defence I’d like to point out that it’s not really as clever as it looks.
 
It’s just that I’ve been doing it for a very, very long time. Let me explain ...
Picture
Genesis
​It goes right back to 1982 and to the BBC Microcomputer. This spawned a word processor called Wordwise Plus, which had a Basic-like programming language for manipulating text (and numbers). 

So, with my love of the English language and a little bit of very basic (Basic) programming skill, I was able to write some useful programs that people were willing to pay money for – £10 a program, if memory serves, sold on 5¼” floppy discs!
Picture
In 1987 Acorn produced their first Archimedes computer (then the fastest desktop computer in the world) and I started publishing a subscription magazine.
 
Every month I would transfer the text of the magazine (produced on an Apple Mac Plus, with its 9” screen!) onto a floppy disc (now 3½”) that I could sell to subscribers (for £2 a month) so that they could electronically search for things in the back issues.
 
For that, I had to do a series of find and replaces (F&Rs) to convert the Mac text to Acorn format, such as changing the Mac’s snazzy fl and fi ligatures to ordinary fl and fi, and proper dashes to hyphens.
 
For this, I kept a list – on a piece of paper! – of the required F&Rs until, eventually, I thought, Surely, this is the sort of thing a computer could do!
Picture
So I asked my subscribers if anyone could write me a program. Paul Sprangers, in the Netherlands, wrote me one, so I started using scripted F&R (think of a text-only version of FRedit).
 
Around 2005, after about 18 years of editing, typesetting and proofreading monthly magazines, I was becoming quite adept at using scripted F&R.
Picture
However, I could foresee the end of my magazine, and began freelance proofreading and then editing. But that meant using Microsoft Word for the very first time in my life – Microsoft was the devil incarnate to a pure Acorn user.
 
So, for the first time in 18 years, I didn’t have the aid of scripted F&R!
 
Then I discovered that Word had a programming language – Visual Basic. I got on to my Acorn contacts again and found someone who could write me a (text-only) scripted F&R program (a macro), then called PreEdit.
Picture
How (not) to win friends ...
By this stage I’d joined the UK’s Society for Editors and Proofreaders (SfEP).
 
I used their email discussion list to ask them newbie questions such as ‘How do I apply a style to a paragraph?’, while at the same time trying to point out to them that they could do their editing jobs much more quickly and easily if they used scripted global F&Rs.
 
Not surprisingly, not everyone was receptive!
 
To put my blunder into context, I’ve recently discovered that, at that stage, Ann Waddingham was pioneering the SfEP’s on-screen editing courses when, in her words in the current issue of SfEP’s Editing Matters, ‘people’s attitudes to on-screen editing were mostly negative. I spent much time ... persuading publishers and editors to take the plunge – both parties were deeply suspicious’.
 
And there was me trying to persuade them to embrace automatic methods of on-screen editing. Oops!
 
So it’s hardly surprising that I upset a lot of people with my evangelical zeal. Sorry, folks!
 
But in my defence, please remember that, at that stage, I had already been using scripted F&R for almost 20 years! I simply couldn’t understand why people weren't able to see its huge power.
Picture
Exodus
It was 2009, and I was enjoying a quiet Sunday lunchtime picnic with Sue, my wife. We were by a river in the Norfolk Broads and it was idyllic: the sun was shining and a beautiful swallowtail butterfly landed not six feet from where we were sitting.

I was trying to concentrate on the book I was reading but my mind kept straying to work issues. In particular, I was thinking about PreEdit, and how the list of F&Rs was held as a text file rather than as a Word file, which made it very cumbersome to use.

... But what if I made the list a Word file? Why should I not use a Word file? No reason on earth. That would make it much easier to use. 

Oh, hang on a minute! If the list was a Word file, then some F&Rs could be bold or italic. And why not consider super/subscript, small caps, styles, highlighting, font colour?

As I thought about it, the excitement mounted. Sunday or no Sunday, I had to go home there and then and do some macro programming.
Picture
A land flowing with milk and macros
With the core tool – FRedit – in place, in 2010 I set about adding tools to speed up my editing in a whole variety of ways: analysing the text for inconsistencies, checking references and citations and speeding up my text editing sentence by sentence.
 
This all supported and enhanced my growing workload of editing scientific books.
 
Unfortunately, relatively few of my colleagues shared my enthusiasm for macros, so I just beavered away, increasing my own efficiency and effectiveness, and sharing my macros, via my website, with anyone who was interested.
Picture
However, in 2015–16, Stephen Cashmore pioneered the SfEP’s new online course, ‘Editing with Word’. The syllabus included a section on using FRedit.
 
The course was a huge success, with many more people taking it than the organisers had dared to hope. It was encouraging to me because it brought me into contact with more and more people wanting to use my macros.
 
In the past year, I’ve started venturing into the (for me, as a technophobe) brave new world of Facebook, joining some of the editorial groups.
 
And there I’ve found a ready acceptance of my ‘new’ ideas. People have been surprised by the range of macros available and have made many encouraging comments.
Picture
The right place at the right time
This brings me back to the original purpose of this post – to demythologize my macros. Remember that I’ve been using scripted global F&R for nearly 30 years and writing VBA macros for almost 10 years.
 
Add to that the fact that in 2008 my business was failing: the magazine was fading away, I had large debts and I feared losing my house. I was therefore highly motivated to develop the means of generating cash, fast!
 
I grabbed anything that would speed me up with both hands.
 
And a more positive factor: I’m absolutely fascinated by the English language (David Crystal is my absolute hero!) and I really love working out how to express things more effectively.

​So macros are a tool for clearing away all the boring, nitty-gritty bits of an editor’s job, allowing me to focus on the meaning and flow of every sentence. This is the most enjoyable job of my whole career.

 
So, if my macros are of help to others then that’s great, and I’m grateful to God that I was in the right place (almost bankrupt!) at the right time.
  • Download Paul's free book: Macros for Editors (and proofreaders!) 
  • Access Paul's free powerhouse macro: FRedit
  • Subscribe to Paul's YouTube channel and watch over 50 video tutorials

Louise Harnby is a fiction copyeditor and proofreader. She curates The Proofreader's Parlour and is the author of several books on business planning and marketing for editors and proofreaders.

Visit her business website at Louise Harnby | Proofreader & Copyeditor, say hello on Twitter at @LouiseHarnby, or connect via Facebook and LinkedIn.

If you're an author, you might like to visit Louise’s Writing Library to access her latest self-publishing resources, all of which are free and available instantly.
Sign up to Louise's blog

0 Comments



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