Microsoft Office Programming: A Guide for Experienced Developers (Paperback)

~ (Author)
Key Phrases: smart tags, connection string, object library, Visual Basic, End Sub, Private Sub (more...)

Editorial Reviews

Product Description

<p>By using the same back-end macro programming language, Visual Basic for Applications (VBA), Microsoft Office applications allow users to easily transfer their VBA programming skills from one Office product to another. A developer skilled at using VBA to program Access can quickly learn to program Word or Excel. Better still, VBA is a fairly complete subset of Visual Basic (VB). That means a VB developer already knows how to use VBA, and a VBA programmer knows a lot about VB.</p>

<p>Author Rod Stephens gives you the most valuable information possible as quickly as possible without rehashing the trivial VB and VBA details you already can recite in your sleep. In <i>Microsoft Office Programming: A Guide for Experienced Developers</i>, Stephens skips the tiresome explanations of variable declarations and dives right into serious Office programming topics, such as automatically customizing menus and toolbars with VBA, making OLE do your work for you, and using ADO to manipulate data in an Access database. </p>

About the Author

In a previous incarnation, Rod Stephens was a mathematician. During his stint at MIT, he discovered the joys of algorithms and graphics, and has been programming professionally ever since. During his career, he has worked on an eclectic assortment of applications spanning such topics as repair dispatch, telephone switch programming, tax processing, and training for professional football players. Rod has written more than a dozen books that have been translated into half a dozen different languages, and more than 200 magazine articles covering Visual Basic, Visual Basic for Applications, Delphi, and Java. million hits per month and contains more than a thousand pages of tips, tricks, and example code for Visual Basic programmers.

Product Details

• Paperback: 736 pages
• Publisher: Apress; 1 edition (October 22, 2003)
• Language: English
• ISBN-10: 1590591216
• ISBN-13: 978-1590591215
• Product Dimensions: 9 x 7 x 1.6 inches
• Shipping Weight: 2.5 pounds (View shipping rates and policies)
• Average Customer Review: 4.5 out of 5 stars  See all reviews (2 customer reviews)
• Amazon.com Sales Rank: #207,065 in Books (See Bestsellers in Books)

Customer Reviews

Most Helpful Customer Reviews

22 of 23 people found the following review helpful:

4.0 out of 5 stars If you're not an Idiot or a Dummy, July 25, 2004

By	W Boudville (Terra, Sol 3) - See all my reviews (TOP 10 REVIEWER)    (REAL NAME)

Microsoft has done an excellent job of integrating its Office suite of products. So if you are familiar with Visual Basic for Applications (VBA), you can use it to programmatically perform tasks within each Office product, like Excel, Word or Powerpoint. Or, within one of these products, you can write an application that can invoke an instance of another program.

Within one book, Stephens shows an efficient and unified way to learn how to do all this, and more. The trick is to be able to use VBA as a macro programming language. This is the key to understanding and using MS Office as a coherent entity. Ultimately, Stephens suggests that it is quicker than learning how to program each product on a case-by-case basis.

Stephens cheerfully dumps on other texts that call you an idiot or dummy. (If you know what I mean.) He unabashedly expects you to be conversant in VB or VBA. To be specific, he doesn't waste time going over the elementary syntactical points of VBA. So you don't have to thumb through these pages in idle frustration. He drags you rapidly into non-trivial coding explanations of how to use VBA to get at MS Office.

3 of 3 people found the following review helpful:

5.0 out of 5 stars Mix and match MS Office, November 9, 2006

By	A. Quintero (PA United States) - See all my reviews (REAL NAME)

Amazon Verified Purchase

This book is the book you need to get you going when you want to use two or more office applications in your own home brewed apps. This book doesn't drag you through learning the basics of VBA but,takes you straight to the meat and potatoes of office development. Shows you the differences in the object models and ways you can use those differences.

It helped me restructure a few access applications to add value and greater functionality to them in my organization. I learned how I could use Excel as a report writer using preformated workbooks and the same with Word. If you want to know more about meshing office apps together without reading through material you already know then this is the book you need.