Create custom business solutions with Microsoft Office XP and Office 2000!
Extend Word, Excel, Outlook, and other Office applications.
Learn all aspects of Office development, including security and distribution.
Leverage Office's powerful collaboration, intranet, and Web capabilities
For novice developers and Office power users!
Discover the power of Office programming
Applies to both Office XP and Office 2000
Master the Visual Basic for Applications (VBA) language and development environment
Understand the powerful components in the Office object model
Build custom tools that leverage email and the Web
Construct four Office applications - step-by-step
No Microsoft Office programming experience necessary!
Developing robust custom solutions with Microsoft Office XP/2000!Microsoft Office is far more than the world's leading office productivity suite. Itspowerful capabilities are organized into hundreds of programmable components, all available to any developer who needs to create custom business solutions. Bycombining these components with the powerful Visual Basic for Applications (VBA) programming language, you can construct powerful applications far more quickly than if you built them from scratch. These components and VBA are available in both Office XP and Office 2000, which means you can use them whether or not you upgraded.
In this book, expert developer and consultant Peter G. Aitken shows exactly how toleverage the power of Microsoft Office in custom application development. Whetheryou're an experienced developer or a business professional with a problem that needssolving, Aitken will show you how to do it with Office — step by step.
Aitken begins by reviewing each key Office application - Word, Excel, Access,PowerPoint, Frontpage, and Outlook - and the shared components accessible to all ofthem. You'll discover powerful opportunities for extending and automating Office to increase efficiency and improve collaboration throughout your organization. Then, onestep at a time, Aitken teaches the key VBA skills you'll need to achieve your goals. Finally, this book walks you through the construction of four real-world Office applications, emphasizing the potential value of Office custom solutions in real-world business situations.
Table of contents
- Prentice Hall PTR Microsoft® Technologies Series
Introduction to Office Development
- Why Develop with Office and VBA?
- The Basics of Office Development
- Visual Basic for Applications—the Fundamentals
- Working with Office Objects
The Office Components
- Using Word Components
- Using Excel Components
- Using Data Access Components
- Using PowerPoint Components
- Using FrontPage Components
- Using Outlook Components
- Using the Shared Office Components
The VBA Language
- Data Storage and Operators
- Conditional and Loop Statements
- Writing Procedures
- Working with Strings
- Working with Dates and Times
- Working with Files
- Creating Custom Classes and Objects
- Creating User Forms
Other Office Development Tools
- VBA Error Handling
- Debugging, Deploying, and Supporting Your Application
- Using the Windows API and Registry
- Office Technologies for the Web
Putting It All To Work
- Web Publishing of a Multiauthor Compound Document
- Numeric Processing and Graphing
- Custom Report Generation
- KeyCode Constants and Values
- Title: Office® XP Development with VBA
- Release date: September 2001
- Publisher(s): Pearson
- ISBN: 9780130654175
You might also like
Excel 2016 Power Programming with VBA
Maximize your Excel experience with VBA Excel 2016 Power Programming with VBA is fully updated to …
F. Scott Barker's Microsoft® Access 2000 Power Programming
Access 2000 Power Programming gives many practical techniques for the corporate and independent developer. New features …
Excel VBA Programming For Dummies
Take your data analysis and Excel programming skills to new heights In order to take Excel …
Microsoft® Offic Excel® 2007 Visual Basic® for Applications Step by Step
Quickly teach yourself how to automate tasks and create custom spreadsheet solutions with Excel 2007 Visual …