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

Cd Chapter 2. Using Visual Basic with Pr... > Why Use Visual Basic Macros?

Why Use Visual Basic Macros?

There are several reasons you might want to use Visual Basic to create macros. This chapter covers some of the most common reasons and gives examples so that you can start creating your own.

Macros were originally used to collect a series of keystrokes that performed a given command or series of commands so that you could run the macro instead of typing the string of commands. This is very useful when the work you are doing is repetitive, such as setting a particular format or printing a particular report. This original functionality evolved and now, instead of just recording and replaying keystrokes, macros can do much more. Microsoft includes Visual Basic for Applications (VBA), a fully functional programming language, in Project as well as other Microsoft Office products. Having a programming language rather than a macro language allows you to program Project to do things that cannot be done by using simple macro functionality. It also allows you to have Project work with other Office applications to achieve the result you want. For example, using VBA, you can have Project send data to Excel and because Excel also uses VBA, you can tell Excel to chart the data in a specific way.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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