Tag Archives: macros

Taking the mystery out of macros – one click at a time

This year’s CIEP conference was held online, from 2 to 4 November. Attendees from all over the world logged on to learn and socialise with their fellow editors and proofreaders, and a number of delegates kindly volunteered to write up the sessions for us. Kate Sotejeff-Wilson reviewed Macros for beginners, presented by Karen Cox.

At Conference Aston, for the 2019 CIEP conference.

Earlier this year, in a Saturday workshop with Paul Beverley, I enthusiastically learned how to use macros, but I still wasn’t integrating them into my daily editing work – despite knowing that macros can do things other software like PerfectIt can’t. So, this was a nice refresher session that I’d recommend to anyone who loves words but finds numbers and computer code slightly terrifying.

Learning macros is a bit like learning to touch type. It takes some time, but once you’re up and running, you will save yourself far more time (and money, as you will be able to edit faster). Karen clearly explained how Paul Beverley’s macros work, with Paul on hand to delve into the details.

A macro is a set of instructions to get your computer to do something for you. They do ‘subroutines’, or small repetitive tasks. Paul divides his into three main types: analysis, as-you-edit and global.

Analysis macros produce reports on your text. You can use the reports to spot inconsistencies and make decisions to incorporate into your style sheet. Run each macro, save the report, and change the document yourself or run other macros to do it. Karen introduced her top three of Paul’s macros:

  • DocAlyse counts instances of spelling, punctuation and formatting (such as whether a capital letter is used after a colon). Karen showed us an example of this using a children’s book she had proofread.
  • ProperNounAlyse shows up instances of place and personal names. Karen used this recently for a novel set in Wales.
  • HyphenAlyse shows up when prefixed words are written as hyphenated, as two words or as a single word (in a self-help book, Karen found anti-depressants and antidepressants).

Two of my personal favourites are CenturyAlyse, which is great for historians, and AccentAlyse, which is great for translators.

Use as-you-edit macros to make changes as problems (like these) come up:

  • ‘CommaInDialogue is great for fiction editors.’ Said Karen. This macro checks whether a full stop is used before a dialogue tag instead of a comma, and corrects it. So you get ‘CommaInDialogue is great for fiction editors,’ said Karen. You can change this with one keyboard shortcut as you work your way through your document.
  • SwapCharacters will correct ‘sepllings’ to ‘spellings’; SwapWords will turn ‘in as’ into ‘as in’.
  • Fetch Macros (GoogleFetch, OUPFetch, GoogleMapFetch) will check how a phrase is spelled, capitalised or located.

Global change macros will change every instance of something in the whole document. Think hard before you do this. These macros need to be used with great care; make sure you save a copy of your file before you start.

  • FRedit is a find-and-replace edit; you create a script for how you want to change these globally. You can use this to do things like turn double spaces into single spaces after a full stop. You can tell FRedit not to Track Changes that you want to make ‘silently’.

Karen closed by showing viewers how to install a macro; why not go to Paul Beverley’s website and try it? You can download a starter pack and book from the site, or go to the CIEP macros forum. Paul will be there to answer your questions.

Kate Sotejeff-Wilson has been editing and translating for academics since starting her history PhD in 1999, and she is happiest in the space between languages or an intercultural setting. Born in Wales to a Polish mother and English father, she is now a Finn. Kate is an Advanced Professional Member of the CIEP and vice-chair of Nordic Editors and Translators.


If you’d like to learn more about Paul’s macros, check out Christina Petrides’ summary of Paul’s Macro-driven book editing session.


CIEP members can download a Getting started with macros fact sheet from within their members’ area.


Posted by Abi Saffrey, CIEP blog coordinator.

The views expressed here do not necessarily reflect those of the CIEP.

What’s e-new? The efficient guide to Word

By Andy Coulson

This issue of The Edit has a theme of working efficiently, so let’s take a look at how we can persuade every editor’s favourite tech tool to work efficiently.

1. Keyboard shortcuts

Keyboard shortcuts are a great little time saver. Think about what you do when you use a mouse – you move it about to try to line up a pointer on a (small) target. You then click and, depending on what you want to do, perhaps repeat this two or more times to get to your command. But with a shortcut you press two or three keys together, and away you go. ‘How-To Geek’ has a really good list.

You don’t have to accept Microsoft’s default choices, either. If you go to Options > Customize Ribbon you’ll see an option at the bottom to customise keyboard shortcuts. This allows you to set up shortcuts for any commands. You can also allocate shortcuts to macros (see below).

2. Styles

Styles offer you a way to quickly format elements of the document. However, they can be a bit fiddly to use. In Word 365, the styles appear in the Home ribbon, as well as in the Quick Access Toolbar at the top. Often you’ll find you use the styles already in the document, and you simply apply them by putting your cursor in the block of text you want to style and then clicking the style name.

But, what do you do when a client says ‘make file A look like file B’? Word has a mechanism to copy styles between documents, but it’s well hidden. You can add the Developer tab to the ribbon, which you do by going into File > Options > Customize Ribbon and selecting ‘Developer’ from the list on the left. Make sure ‘Main Tabs’ is selected at the top of the list on the right and then click ‘Add’.

In the Developer tab, click on ‘Document Templates’, and then ‘Organizer’ in the ‘Templates’ tab of the pop-up box. You will see two lists. The one on the left should have the file name of your current document underneath. On the right-hand one, click ‘Close File’, and this will clear the list, then change to ‘Open File’. Click on it and select the template or document you want to import from. You can then simply select the styles you want and click the ‘Copy’ button to import these to your document.

3. Wildcards

If you use Find and Replace, learning to use wildcards will transform your searching. These allow you to look for patterns rather than specific words. For example, ‘?ed’ tells Word to find ‘ed’ preceded by any other single character, so it would find ‘red’, ‘bed’, ‘Red’ or ‘Bed’ and so on. This can get complicated, but it can also be a real time saver. One of my favourite applications is cleaning up question numbering in textbooks where I can’t use auto-numbering. Here, searching for ‘([0-9]{1,2})\)^s’ and replacing with ‘\1^t’ would change one- or two-digit numbering like this: ‘1.<space>’ to ‘1<tab>’.

There are an awful lot of options, and one place to find help on these is Jack Lyon’s Wildcard Cookbook for Microsoft Word, which is available as a PDF ebook. I have it open in my ebook reader most of the time I’m editing in Word. Geoff Hart’s Effective Onscreen Editing also has a chapter on making the most of Find and Replace.

4. Macros

Macros are short programs that build on the capabilities of Word. They often link together a number of functions within Word to achieve a more complex task, be that something which finds information about the document, changes what you have selected or makes global changes.

Many of you will be aware of Paul Beverley and his macros, and I can’t suggest a better way in to macros than Paul’s Macros by the tourist route. This is a really good introduction to using macros, and will lead you to Paul’s amazing macro library. Once you get into using these you can really start saving time on your work in Word.

Among my favourites are DocAlyse, which runs a range of tests on a document to flag the types of issues it may have; WhatChar, which identifies any character; SpellingErrorLister, which creates a list of potential spelling errors; and HyphenAlyse, which identifies the frequency of hyphenated words (and their non-hyphenated equivalents) and checks common prefixes.

The CIEP has also produced a fact sheet about getting started with macros.

5. Add-ins

Add-ins go a step further than macros. They are programs that work within Word to add more functions. Many of you will have heard of PerfectIt, and this is a good example. PerfectIt will check consistency in the document in a way that Word’s tools simply can’t. You can install stylesheets to suit particular clients (or create your own). I recently had a job using Chicago style (CMOS), and through the forums (thanks, Hilary Cadman!) found a ready-built one that was a big help.

PerfectIt is not the only add-in you can use. I’ve talked about ClipX before, which is an add-in to Windows rather than Word. It’s a clipboard expander that allows you to see the last 25 entries in your clipboard, so you can reuse them. I’ve just discovered it too has add-ins and one, Stickies, maintains a constant list of entries. I use this a lot when I’m manually tagging a file, so I can quickly insert tags.

6. Learn Word

I’ve saved this for last, but perhaps it should be first. Invest some time in learning to use Word to its full potential, as it will repay you time and again. Many of the things above are rooted in a knowledge of how best to use Word. As you get more familiar with Word you’ll be able to customise your set-up, helping you to use it more efficiently. A great resource to help with this is the CIEP course Editing with Word. This will give you a good introduction to many of the things I’ve talked about above.

Andy Coulson is a reformed engineer and primary teacher, and a Professional Member of CIEP. He is a copyeditor and proofreader specialising In STEM subjects and odd formats like LaTeX.

 

 


‘What’s e-new?’ was a regular column in the SfEP’s magazine for members, Editing Matters. The column has moved onto the blog until its new home on the CIEP website is ready.

Members can browse the Editing Matters back catalogue through the Members’ Area.


Photo credits: keyboard – Halacious; tourist map – pixpoetry, both on Unsplash

Proofread by Emma Easy, Intermediate Member.
Posted by Abi Saffrey, CIEP blog coordinator.

The views expressed here do not necessarily reflect those of the CIEP.

How to customise PerfectIt to check your house style

By Daniel Heuman

PerfectItBuilding customised style sheets in PerfectIt helps make sure that all documents you work on reflect your or your client’s preferences for spelling, hyphenation, capitalisation, italics, and other house style choices. There are two ways to build preferences into a PerfectIt style sheet. You can either:

  • Commission Intelligent Editing to prepare the style sheet for you. For government departments, NGOs, and Fortune 500 companies, this is the best way to develop the most comprehensive style sheet possible.
  • Prepare the style sheet yourself. For freelancers and small companies, this lets you put together your own style sheet that is customised to your needs without any additional cost.

To have a style sheet prepared for you, you can get a quote from Intelligent Editing. This article is for people who want to prepare their own style sheet. It guides you through ten short videos that, in less than one hour, will teach you how to prepare your style sheet.

Do I need to customise PerfectIt?

PerfectIt doesn’t need any kind of customisation. You can use it to check consistency without altering any settings. Just run it, click ‘Start’, and the interface guides you through the rest. Most people find that’s all they need, without any customisation. If you haven’t ever used PerfectIt, start with the free trial, which you can download here.

PerfectIt also comes with a number of built-in styles, including European Union, Australian Government, World Health Organization, and United Nations styles. If you’re using those (or if you just want to check UK, US, Canadian, or Australian spelling), you can use the built-in styles without any customisation. Just select the style that you want before you press ‘Start’. You only need to customise PerfectIt if you want it to check your specific house style.

Creating a new style

If you’ve decided that you do want to customise PerfectIt and are ready to learn more, the first thing to do is to add a new style. This video explains how:

You can have one style sheet for every style manual (or client) that you work with. So repeat those steps for every style sheet that you want to create.

Customising settings

When you’ve created a new style sheet, you can edit it in PerfectIt’s style sheet editor. This video looks at the ‘Settings’ tab and shows how to check your preferences for lists, compounds, and headings. For example, you can set PerfectIt to enforce punctuation at the end of a bulleted list or to control title case in headings:

The next video shows how to use the settings for numbers in sentences and Oxford (serial) commas. You can turn Oxford commas off or on, and you can choose whether numbers in sentences should be spelled out or presented in numerals. In addition, it shows how to set a number of style points such as thousand separators and non-breaking spaces in measurements and dates:

Search and replace

You can modify PerfectIt’s tests by adding particular words that PerfectIt should find. In addition, you can choose words or phrases that PerfectIt should suggest as fixes. To see this, go to the ‘Always Find’ tab in PerfectIt’s style sheet editor. Each test within that tab is a little different. This video shows how to add searches to the tests of hyphenation, dashes, accents, and phrases in capitals:

The next video looks at PerfectIt’s different tests of spelling as well as the test of phrases to consider:

The final video on the ‘Always Find’ tab covers the test of comments that are accidentally left in the text and the test of abbreviations that appear in two forms. Then there is a more advanced tip on adding exceptions:

Additional tests

PerfectIt’s style sheet editor has tabs for PerfectIt’s tests of italics, prefixes, and superscripts and subscripts. This video covers all three, and shows how, in addition to switching the settings, you can add additional words/phrases to each test:

If you’re not familiar with wildcard searches in Word, it’s worth reading up on those before watching the next video. Two great sources to look at are Jack Lyon’s Advanced Find and Replace for Microsoft Word (an especially good resource for beginners) and Graham Mayor’s article on Finding and Replacing Characters Using Wildcards (a useful reminder for users who are already familiar with the concepts of wildcard search).

For those who are comfortable with wildcards, this video shows how you can include them in a PerfectIt style sheet:

An even easier way

The videos above explain all of the features in PerfectIt’s style sheet editor. However, if you’re concerned about the time involved in entering all the preferences in your style manual, there is a way to complete the task gradually. And it’s really easy. This video shows how you can amend a style sheet as you work without ever opening up PerfectIt’s style sheet editor:

Sharing styles

The great thing about style sheets is that it only takes one person to prepare them. After that, you can share the style with anyone at your organisation. This video shows how to share your style:

Slow and steady…

If you have spare time to set aside to prepare a style sheet, that’s fantastic. But that’s a luxury that many people don’t have. So what we recommend is to start with an existing style and amend that (as shown in the first video above). Then go through and complete the preferences in the ‘Settings’ tab (the second and third videos). Then stop and just do a few minutes per day after that. Adding to styles incrementally as you work is easy (the ninth video). And if you add just two or three items to a style sheet with each document you check, then you’ll quickly have a style sheet that saves time and improves checking for everyone at your organisation. And it doesn’t cost a penny extra!

Daniel HeumanDaniel Heuman is the Founder and CEO of Intelligent Editing as well as the developer of PerfectIt.

 

The views expressed here do not necessarily reflect those of the SfEP.