YOURS TRULEIGH EDITING
  • Home
  • Services
  • Portfolio
  • Testimonials
  • Contact
  • Blog

16/3/2021

'I’ll never get my head around macros and wildcards'

0 Comments

Read Now
 
'I’ll never get my head around macros and wildcards!' I hear this quite a lot and, I have to confess, I have to make sure that I only sigh on the inside. I hope that having read my Macro baby steps posts that you will realise almost everyone who uses a computer to edit (or proofread) text should be able to install and/or record at least a few simple macros. I am equally convinced that most editors could keep a list of handy wildcards to use on occasions. But, people talk about these things as if macros and wildcards are essentially the same thing – which they are not –  and as if they are equally baffling, whereas, in fact, they are quite different and making use of each needs a different set of skills. 

Macros

A macro is basically a set of instructions that automates an action or a sequence of actions. In Word, you access, create or record your macros via the ‘Macros’ menu on the ‘View’ tab or the ‘Developer’ tab. Macros are useful for editors because automating a sequence of actions can save us a lot of typing and, therefore, time. The macro never gets tired, so will repeat the sequence of actions as many times as we want and will be as accurate at the end as it was at the beginning.
​
Macros can be extremely simple ...
Picture
​... or they can be quite complex ...
Picture
Macros can make changes in your documents or can produce new documents which contain information about your document while leaving the original document untouched (have a look at some of Paul Beverley’s document analysis macros).

​If you want to write your own macros, you have to use a programming language called Visual Basic for Applications (VBA). ​ 

Picture
VBA is a cut-down version of a programming language and is designed so that people who aren’t computer programmers can program their own macros. Obviously, some of us find any level of computer programming quite a scary prospect, so Word also allows us create macros by recording our own sequence of events that we want to automate without having to worry about learning to program at all.

Word allows us to edit our macros if we want to (see How to edit a macro), which can be handy if you have a macro that does one thing (eg, counts up in 1s) and you want it to do something similar but not quite the same (eg, count up in 2s).

​Sometimes updates in Word or VBA can mean that macros will just stop working and so they have to be edited to make them work again.

VBA doesn’t allow you to make macros that look “pretty”, so any boxes that pop-up with questions, or any text that a macro produces will tend to look like they are straight out of a 1980s sci-fi movie.*

Once you have a macro that works well, and you have added it as an icon on your Quick Access Toolbar, or assigned a keyboard shortcut to run it, you should be able to use your macro with very little thought.

​Wildcards – or Word wildcard search and replace

​In card games, “wild cards” are playing cards that can be used to represent another playing card.
​ 
In Word, a wildcard search is a search that uses symbols to represent categories of the things that you want to search for ie, numbers, lower-case words, upper-case words, words with initial caps, numbers separated by hyphens etc.
Picture
This doesn’t sound particularly useful until a document lands on your desk in which all the:
  • number ranges use hyphens and not en-rules
  • dates are written in US rather than UK format (or vice versa, of course)
  • footnote markers are the wrong side of the punctuation
Ordinary search and replace won’t help you here because every instance of these examples will have different text, but it’s possible to describe each of these examples in a standard way, ie:
Picture
  • [number]-[number]
  • [Word with initial cap]<space>[1–2 digit number],<space>[4 digit number]
  • [footnote marker][punctuation mark]
Once you have worked out what pattern the changes you want to make follow, you need to work out the wildcard symbols that describe these categories. The Replace function duplicates the text found by the search so you can replace the hyphens between entirely different sets of numbers, as in the first example, or to move text around as in the other examples.

Getting to grips with writing wildcard searches does take a little practice, but I will write a post to help you get going. Once you understand the principles you should be able to keep a set of wildcard searches that other people have written and adapt them to use on your own documents.


The advantage of wildcard searches is that they are very specific, so they will only find exactly what you ask them to find. It might not surprise you to know, that this is also the thing that makes them extremely tricky. If you have typed in a search that looks for something that is ever so slightly different from what is in your document, the search won’t find anything – and there are no friendly messages that pop up saying “You searched for something that looks a bit like this, is this what you meant?”.  This means that everybody who uses wildcards will spend a certain amount of time scratching their heads, wondering what they have done wrong (one of the most common things is not ticking ‘Use wildcards’  in the search function!).
​
Having said that, once you have got your wildcard searches sorted out, they do save a lot of time tidying up those mechanical jobs (eg, references!) that are a nightmare to do by hand.**
Picture

*It is possible to make Word tools that look more professional than most macros, but you need to use Word Add-Ins which have to be created by professional programmers (or, at least a programmer who knows what they are doing). One of the best-known Word Add-Ins is PerfectIt – which is one of the editing tools that I think everyone should have.

**The latest versions of PerfectIt have a Wildcards section in the stylesheet editor so I  save as many of my wildcard searches there to save me having to create them from scratch every time.

Author

Andrea at Yours Truleigh Editing.
www.yourstruleighediting.com
​

Picture

Archives

October 2021
August 2021
July 2021
June 2021
March 2021
February 2021
January 2021
December 2020

Categories

All
Beginner
CIEP
Editorial Training
Intermediate
Macro Baby Steps
Macros
PDF
PerfectIt
StetSwim
Word Basics
Word Styles
Working With Word

Share

0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

Details

    Author

    Andrea at Yours Truleigh Editing
    I'm an editor based on the south coast of the United Kingdom. I try and use the tools at my disposal to make the process of editing as effiicient and accurate as possible and I'm hoping to share some tips and techniques that I've picked up along the way. I'm an enthusiastic and grateful member of the Chartered Institute of Editing and Proofreading. Editorial freelancers benefit hugely from being part of supportive organisations:  for direct support for our work, such as training and providing routes for our clients to find us, but also for community, which is needed now more than ever. 
    Please note: all Word tips are based on Word 365 for PC. 

    Archives

    December 2021
    October 2021
    August 2021
    July 2021
    June 2021
    March 2021
    February 2021
    January 2021
    December 2020

    Categories

    All
    Beginner
    CIEP
    Editorial Training
    Intermediate
    Macro Baby Steps
    Macros
    Music
    PDF
    PerfectIt
    StetSwim
    Time Off
    Word Basics
    Word Styles
    Working With Word

    RSS Feed

Dr Andrea Kay
​Medical Editor | ​Yours Truleigh Editing

© COPYRIGHT 2023. ALL RIGHTS RESERVED.
  • Home
  • Services
  • Portfolio
  • Testimonials
  • Contact
  • Blog