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

18.1. What Is VBA?

VBA is a subset of the Visual Basic programming language. It is a hosted language component, meaning that an application provides the environment in which VBA code is written and executed. In Office 97, all Office applications except Outlook were viable hosts for VBA. With the Office 2000 release, Outlook can host it as well.

With each host application comes a different flavor of VBA. It is typically used to extend the functionality of the hosting application through the application's object model . An object model is a hierarchy of logical entities (objects), such as a word processing document in Word, a spreadsheet in Excel, or the preview pane in Outlook. By using an application's object model (explained later in this chapter), you can programmatically perform standard operations—like creating a new contact—and more complex logical tasks, some of which may require interaction with the user.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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