Chapter 11: Extending Office Data Analysis Features with Code


Overview

Many of the Microsoft Office data analysis features that you’ve read about and experimented with so far in this book can be automated through the use of programmatic code. Once you understand how to work with the Visual Basic Editor, the primary development environment used to write code for Office applications, you’ll be better prepared to automate Office data analysis features.

To help lay a foundation for programming Office applications, this chapter begins with a discussion of Office code macros and procedures, which are collections of code that perform certain tasks, and then provides and explains code examples that relate to specific Office data analysis tasks and features. If you’re familiar with at least one high-level programming language (Microsoft Visual Basic, for example), you will see some specific examples and gain some background about Office development. If you’re not familiar with programming, while this chapter can’t be a thorough introduction, you’ll still gain an understanding of some fundamental concepts and see the direction that you need to go.

Note

The code samples in this chapter are written for Microsoft Office XP applications. For information about writing solutions for Office 2000, see the Office Visual Basic Help included with Office 2000 or visit the Microsoft Developer Network (MSDN) Web site at http://msdn.microsoft.com.

Objectives

start example

In this chapter you will learn

  • How Office code macros and procedures work.

  • How the Office programmatic object models work.

  • How to use code to access the data analysis features in Microsoft Excel, Microsoft Access, the Microsoft Office Web Components, and Microsoft Data Analyzer.

end example




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