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

Summary

Many of the Office data analysis features can be extended through the use of code. For simple data analysis tasks, you can program macros, consisting of one or more procedures, in the Office Visual Basic Editor. Office macros are typically programmed using Visual Basic for Applications (VBA) code. The Microsoft Office Web Components and Microsoft Data Analyzer are two exceptions. In these cases, you host the Office Web Components on a Web page or you host Data Analyzer as an ActiveX control on a 32-bit form container or a Web page. For Office data analysis solutions based on Web pages, you can use Visual Basic Scripting Edition (VBScript) code. For other programmatic containers, you use the host application’s programming language.

Before you can program Office data analysis solutions, you must understand the Office object models, including their objects, collections, properties, methods, events, types, and constants. You can explore the Office object models by using the Object Browser and the Office VBA Language Reference, both of which are accessed through the Visual Basic Editor. Before you can program any Office object model, you must set a reference to it. Most of the Office object models are traversed beginning with the Application object.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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