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.

In the next chapter, “Maintaining Data Reporting and Analysis Systems,” you will learn how to maintain Microsoft Access and Microsoft SQL Server 2000 databases.




Accessing and Analyzing Data With Microsoft Excel
Accessing and Analyzing Data with Microsoft Excel (Bpg-Other)
ISBN: 073561895X
EAN: 2147483647
Year: 2006
Pages: 137
Authors: Paul Cornell

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net