• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 22. Automating Your Work with Ma... > Automating Repetitive Tasks with a M...

Automating Repetitive Tasks with a Macro

What tasks can be automated? Virtually anything that can be created on the keyboard can be automated with a macro. There are two caveats here:

  • The macro recorder only records what is going on in PowerPoint. If you switch to Excel during the recording of a macro, the recorder does not record the process in Excel. There are ways to activate other programs like Excel, but that has to be performed with specifically written code and not through the macro recorder.

  • Some things that may be recorded may not be performed often enough to warrant the time involved in creating a macro. You need to decide if the time involved to automate a simple task outweighs the amount of time that may be necessary to do it manually whenever that situation arises.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint