- Shopping Bag ( 0 items )
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.
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 Microsoft Office Programming: A Guide for Experienced Developers, 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 Object Linking and Embedding (OLE) do your work for you, and using ADO to manipulate data in an Access database.
|About the Author|
|About the Technical Reviewer|
|Ch. 3||Customizing Office||55|
|Ch. 4||Automatic Customization||87|
|Ch. 5||Office Programming the Easy Way: OLE||141|
|Ch. 6||Introduction to Office XP Object Models||223|
|Ch. 11||Access and ADO||523|
|Ch. 13||Outlook, MAPI, and CDO||591|
|Ch. 14||Smart Tags||611|
|Ch. 15||Office 2003||637|
Posted July 25, 2004
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.Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.