VBA for Microsoft Office 2000 Unleashed
(Unleash the power of Visual Basic for Applications for Microsoft Office 2000)

by Paul McFedries

Amazon.com

In Visual Basic for Applications (VBA) for Office 2000, the line between macros and full-fledged programs has blurred more than ever. VBA for Microsoft Office 2000 assumes you have no programming experience and teaches you how to take full advantage of the considerable customization options that VBA offers.

This book takes a conventional--and generally effective--approach to the problem of teaching a nonprogrammer how to write computer code. After a quick orientation to the Visual Basic Editor, the process of running your code, and the overall structure of VBA modules, the author explains core language elements. You'll learn about variables, operators, and--in general terms--objects. This grounding prepares you for the sections that reveal VBA objects exposed by Word, Excel, PowerPoint, and Access. Though he provides decent coverage of objects and their general use, it would be better if the book were organized in a way that made reference easier.

VBA has plenty of power to build user interfaces for databases, and VBA for Microsoft Office 2000 covers those capabilities in some detail. This book supplies substantial insight that will enable you to program with references to Data Access Objects (DAO), Jet databases, and open database connectivity (ODBC) Direct workspaces. (Sample code is included.) There's also information on the objects that facilitate network publishing. --David Wall

Book Description

With the release of Office 2000, Microsoft has finally achieved its goal. Now all Office products--Word, Excel, Access, and PowerPoint, have a VBA development environment at their core. VBA plays a huge role in Microsoft's future plans. Anyone interested in truly unleashing the power of the Office applications will need to learn the VBA language. With Visual Basic Applications for Office 2000 Unleashed, you'll be able to create useful procedures that enable your applications to perform like they never have before. Topics covered include OLE and ActiveX Objects; Building VBA Expressions; Working with Objects; Class Modules; VBA and Database Programming; Creating Custom Menus and Toolbars; Debugging VBA Procedures; and Programming the Windows API.

 

Synopsis: (from back cover)

Table of Contents

VBA Programming Language (p. 7)

1. Introducing VBA
2. Understanding Variables
3. Building VBA Expressions
4. Working With Objects
5. Controlling Your VBA Code

Microsoft Office Objects (p. 167)

6. Word 2000 VBA Programming
7. Manipulating Excel 2000 with VBA
8. Programming PowerPoint 2000 Presentations
9. VBA and Access 2000

VBA User Interface Design (p. 341)

10. Interacting with the User
11. Working with Microsoft Forms
12. Creating Custom Menus and Toolbars

Application Integration (p. 437)

13. Working with Other Applications
14. Programming OLE and ActiveX Objects
15. Controlling Applications via Automation
16. Rolling Your Own Objects with Class Modules

VBA Database Programming (p. 527)

17. Using VBA to Work with Excel Lists
18. Programming Data Access Objects
19. Advanced Database Programming

VBA Internet and Intranet Programming (p. 639)

20. Internet and Intranet Programming Topics
21. HTML Programming: BVScript and the Script Editor
22. Email Programming with Outlook

Advanced VBA Programming (p. 739)

23. Trapping Programming Errors
24. Debugging VBA Procedures
25. Programming the Windows API
26. VBA Tips and Techniques

VBA Applications (p. 861)

27. An Excel Checkbook Application
28. Making Backus as You Work
29. Access and Outlook: Email Merge

Appendixes [sic] (p. 971)

1. VBA Statements
2. VBA Functions
3. Programming the Windows Scripting Host
4. The Windows ANSI Character Set
5. HTML Primer

Index

 

Go to Amazon.com to order VBA for Microsoft Office 2000 Unleashed: (Unleash the power of Visual Basic for Applications for Microsoft Office 2000)

Go to Amazon-UK to order VBA for Microsoft Office 2000 Unleashed: (Unleash the power of Visual Basic for Applications for Microsoft Office 2000)
PAPERBACK

Return to What are some good books for me to read about Word

 

Enter your e-mail address to receive e-mail when the selected pages are updated.
You can select multiple pages.
Your Internet e-mail address:
Microsoft Word Books VBA for Microsoft Office 2000 Unleashed by Paul McFedries (this page)