×

Uh-oh, it looks like your Internet Explorer is out of date.

For a better shopping experience, please upgrade now.

Developing Solutions with Office 2000 Components and VBA
     

Developing Solutions with Office 2000 Components and VBA

by AITKEN, Peter Aitken
 

The Professional's Guide to Developing Custom Solutions with Office 2000!

  • Develop custom applications with Office 2000
  • Exploit the power of the VBA language
  • Leverage the power of intranets and the Internet

Create custom business solutions with Office 2000 and watch your productivity soar.

Built right into the

Overview

The Professional's Guide to Developing Custom Solutions with Office 2000!

  • Develop custom applications with Office 2000
  • Exploit the power of the VBA language
  • Leverage the power of intranets and the Internet

Create custom business solutions with Office 2000 and watch your productivity soar.

Built right into the Microsoft Office applications on your desktop are more than 600 powerful software components and a full featured programming language, Visual Basic for Applications. You can use these tools to create custom applications to streamline your workflow and boost efficiency.

The six main Office applications-Word, Excel, Access, PowerPoint, FrontPage, and Outlook—all work on the object model. With this step-by-step guide, you'll quickly master the paradigm and get down to building the exact software that suits your needs. Working hands-on from the very start, you'll be building real applications and mastering real skills, such as:

  • Creating custom documents, charts, and reports
  • Designing customized visual interfaces
  • Controlling data access and managing security
  • Creating and publishing Web content
  • Automating e-mail tasks

You will work easily within the familiar Office framework to develop sophisticated business solutions with these simple, widely available tools.

Product Details

ISBN-13:
9780130263056
Publisher:
Prentice Hall
Publication date:
05/26/2000
Series:
Prentice Hall Microsoft Technology Series
Pages:
528
Product dimensions:
7.20(w) x 9.00(h) x 1.30(d)

Read an Excerpt

PREFACE:

Preface

When most people think of Microsoft Office, they think of a powerful set of office applications-Word for word processing, Excel for spreadsheets, Access for databases, and so on. There is, however, much more to Office than that. Hidden behind the application's programs is a powerful set of development tools that can be used to create sophisticated custom solutions to address specific needs. The foundation of these development capabilities is the Office object model, a rich set of programmable objects, sometimes referred to as software components. These components provide the functionality of the individual applications that make up Office, and are also available for customized programming. When combined with the powerful Visual Basic for Applications (VBA) programming language, also part of Office, the result is a powerful and flexible development tool that is often your best choice when faced with a Windows development project.

Is Office a replacement for traditional programming languages such as Visual Basic, C++, and Java? In a word, no. From the developer's perspective, Office is specialized for creating custom applications that perform the same general sorts of tasks that the Office applications themselves do-manipulate text, work with numbers, display graphs, send and receive e-mail, and so on. Since it is exactly this type of functionality that is often needed, there are many situations in which Office will be your best choice of development tools. Outside this area, however, Office is not a good choice. For example, an astronomer writing a program to analyze crater patterns on Mars would not turn to Office. There are so many situationsin which Office is the best choice that any Windows developer really should have some familiarity with its capabilities. Office may be your only development tool, or it may be one of half a dozen that you use, but it cannot be ignored.

This book is aimed at individuals who are at the beginner and intermediate level and who want to use Office to develop custom solutions. No previous programming experience is required, although if you do have such experience, particularly with Visual Basic, you'll be able to work through some sections of the book more quickly, Part Three in particular. My approach is a combination of reference material and demonstrations. I am a strong believer in learning by doing, and I feel that the best approach to learning how to use a development tool is a mixture of presenting the raw information you need, and showing you how it is used in a real-world situation.

I make no pretense of covering all the details of Office development. There is no way a single book can include all the related information, and even if such a book were possible, no one would want to read it. My goal is to cover to most important fundamentals of Office-those tools and techniques that you will need most often. Once you understand these fundamentals, it is an easy matter to turn to the online reference materials for the details that could not be included in the book.

Meet the Author

Peter G. Aitken has written more than 25 books on computer-related topics with a special focus on programming. His consulting firm delivers custom Office and Visual Basic solutions to businesses, government, and universities. He is also a contributing editor at Visual Developer magazine, where he writes a popular column on Visual Basic development.

Customer Reviews

Average Review:

Post to your social network

     

Most Helpful Customer Reviews

See all customer reviews