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.
Book Description
Editorial Reviews
Amazon.com Review
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
From the Back Cover
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.
Product Details
Would you like to update product info or give feedback on images?
|
More About the Author
Paul McFedries runs Logophilia Limited, a technical writing company, and has been writing computer books for more than 17 years. He is the author or coauthor of more than 60 books that have sold more than 3 million copies worldwide. Paul is also the proprietor of Wordspy.com, a website that tracks new words and phrases as they enter the language.
Customer Reviews
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
|
Most Helpful Customer Reviews
6 of 7 people found the following review helpful:
1.0 out of 5 stars
PowerPoint Samples have compile and runtime errors.,
By A Customer
This review is from: Visual Basic Applications for Office 2000 Unleashed (Paperback)
I normally buy these type of books to save time by getting sample apps that work immediately. Instead, I had to spend my time fixing compile and runtime errors with the PowerPoint Sample code and the author neglected to give you any clue on what reference libraries were needed.
3 of 3 people found the following review helpful:
5.0 out of 5 stars
Outstanding Book!,
By Bunny Bear (Brooklyn, NY) - See all my reviews
This review is from: Visual Basic Applications for Office 2000 Unleashed (Paperback)
This book covers a ton of good information. Good explanations are given for the examples. Contains real world examples, very useful. I'm getting the best out of the book by reading it all through and running and stepping through the examples. The book does contain a few errors, but very little to make a difference. I'm glad that I bought this book. So will you.
5.0 out of 5 stars
Still Useful,
By
Amazon Verified Purchase(What's this?)
This review is from: Visual Basic Applications for Office 2000 Unleashed (Paperback)
I still make good use of this book - I'm a bit taken aback to now realize in 2010 that 10 years have passed since Windows 2000 and Office 2000. But then I still use my BIC four-colored pen, too... Ha !!! Books such as this one are often useful for orientation - they give a sense of the game and the rules. Which when doing hand-crafted programming is a great boon !!! :)
Share your thoughts with other customers: Create your own review
|
|
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organize and find favorite items. |
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
Customer Discussions
|
This product's forum
Active discussions in related forums
Search Customer Discussions
|
Related forums
|
