Use Macros to save time

Blog Author: Aaron Smith | February 25th, 2015

If you spend a lot of time doing the same tasks in Office applications like Word and Excel then you may not be aware that there is tool within these applications that allows you to record and replay these steps for you.

To record a set of actions into a Macro in an Office application select the View tab and then the Macros button on the right of the Ribbon Menu.

You’ll then be prompted to enter a name for your macro. With that complete all commands you now execute will be recorded. When you have completed the action again select the View and Macros button from the Ribbon Menu. Select Stop Recording to end the sequence.

You can now return to the Macro menu at any time to replay the commands you recorded in that macro. You can also assign that macro to a hot key sequence as well as a button on the Ribbon Menu if desired.

You can also actually drill into the macro to view the code if you want. It is also possible to directly code a macro to create very complex programs to complete just about any task that the application is capable of. It is so powerful ,in fact, that you could code and create your own application based on one of the Office applications if you really wanted to.

In summary, if you are regularly repeating the same process in Microsoft Office applications then you should look into the functionality that macro automation provides. The simplest way to create a macro is to record a sequence of steps and then replay them. However, macros are very, very powerful components of Microsoft applications and can be extended through direct coding to do just about anything. Remember, if you don’t have the skills to create these macros you can always get an expert in to do it for you.

For help with any of the Microsoft applications on your desktop contact us here at Correct on (02) 8831 8200.

Image courtesy of Michelle Meiklejohn at FreeDigitalPhotos.net

Have A Question?
Fill In The Form Below

CORRECT SOLUTIONS

  • Unit 3 • 7 Anella Avenue Castle Hill, NSW 2154
  • Suite B • 3 Somerset Avenue Narellan, NSW 2567
Map