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

Chapter 27. Introduction to Visual Basic... > Recording VBA Macros for Project

Recording VBA Macros for Project

Recording a macro works well for simple tasks such as printing a particular view or report. It is also useful when you want to see how Project records an action when programming larger, more complex macros. Beyond that, recording complete macros becomes less productive because the more complex the task, the more manual coding you will need to do. By learning to code manually, your programming will be done more quickly and effectively. Recorded macros might work properly when run immediately, but are likely to produce undesirable results when run the next day, week, or month.

For example, typical things that change and can stop a recorded macro are blank tasks or resources being added, extra tasks or resources being added or deleted, names being changed, and project files that need to be open being closed, or closed ones being open and changing dates. All these changes can be managed, but only by manually editing the recorded macro. As you become more experienced, you will find yourself writing more and more of your code and recording less and less. Until then, it's best that you use macro recording to automate simple tasks and give you sample code to get you started and to show you how to code some of the many Project commands. With that in mind, let's take a look at how to create basic macros.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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