Feeds

VSTO For Mere Mortals

Assuming that Office Power Users think of themselves as mortals...

Secure remote control for conventional and virtual desktops

Book review In addition to the legions of professional Visual Basic programmers, there are still more developers who use VBA and Microsoft Office for automation, customisation or the development of tailored office applications. Many of these are super-users rather full-time developers, but they have depended on VBA to extend and expand what it is they can do with Excel, Office, Access et al.

While Microsoft has devoted a lot of energy to helping the VB 6.0 developer move to Visual Basic .NET (which later morphed into Visual Basic 2005, in a move many saw as an attempt to woo those developers who hadn’t yet made the jump to the .NET universe), the road map for VBA developers has been less clear-cut.

For VBA programmers, the initial appeal of .NET was limited, not only because the initial release of Visual Basic .NET was missing some of the RAD features that VB developers knew and loved, but also because of the difficulties of switching to a completely different programming model, to the complexities of the .NET framework, Visual Studio and the Visual Studio Tools for Office (VSTO). Somewhere along the line doing Office application development in .NET gained the reputation of being difficult, particularly for those still supporting older versions of Office.

This is where ‘VSTO For Mere Mortals’ steps in. It isn’t a book pitched at the professional VB developer, many of whom had already started to move to objects and classes in VB 6.0. Instead this book is squarely aimed at the VBA programmer – professional or otherwise – who wants to take those first steps into the new world of Office development with VSTO. For starters, the book doesn’t take much time to look at C#, object orientation or the detailed architecture of the .NET framework. The focus is clearly on making practical use of Visual Basic 2005 and VSTO to extend and control Excel, Word and Outlook.

The opening section of the book is about the new environment: an introduction to the .NET framework, an introduction to VB 2005 (and how it differs from VBA), the new world of Visual Studio 2005 and VSTO. This is the core material needed to get started, but it's in the second section of the book that the pace picks up. Here five chapters are devoted to Word and Excel only, looking at customisation with VSTO, task and action panes, user controls, smart tags and so on.

It’s not just the programming models that have changed however. The final section of the book looks are broader issues such as deployment, security, Outlook add-ins, application migration and more. There is also a chapter on the next release of VSTO and the changes brought on by the arrival of Microsoft Office 2007.

While the experienced developer might find a lack of technical depth, particularly as regards the handling of object orientation and the architecture of the .NET framework, for the VBA developer anxious about moving to VSTO the book is about right. It strikes the right note in getting the reader to a point where it all makes sense, including oft neglected topics such as the debugging of Office applications in the new world.

VSTO For Mere Mortals

Verdict: A useful introduction to those wanting to take their first .NET steps to automating and customising Word, Excel and Outlook.

Authors: Kathleen McGrath and Paul Stubbs

Publisher: Addison Wesley

ISBN: 0321426711

Media: Book

List Price: £31.99

Current Reg price: £21.43 inc. VAT (discount 33%)

Buy this book at Register Books at Reg Developer's special discounted price (subject to change)!

Beginner's guide to SSL certificates

More from The Register

next story
Microsoft to bake Skype into IE, without plugins
Redmond thinks the Object Real-Time Communications API for WebRTC is ready to roll
Mozilla: Spidermonkey ATE Apple's JavaScriptCore, THRASHED Google V8
Moz man claims the win on rivals' own benchmarks
Microsoft promises Windows 10 will mean two-factor auth for all
Sneak peek at security features Redmond's baking into new OS
FTDI yanks chip-bricking driver from Windows Update, vows to fight on
Next driver to battle fake chips with 'non-invasive' methods
DEATH by PowerPoint: Microsoft warns of 0-day attack hidden in slides
Might put out patch in update, might chuck it out sooner
Ubuntu 14.10 tries pulling a Steve Ballmer on cloudy offerings
Oi, Windows, centOS and openSUSE – behave, we're all friends here
Apple's OS X Yosemite slurps UNSAVED docs into iCloud
Docs, email contacts... shhhlooop, up it goes
Was ist das? Eine neue Suse Linux Enterprise? Ausgezeichnet!
Version 12 first major-number Suse release since 2009
prev story

Whitepapers

Cloud and hybrid-cloud data protection for VMware
Learn how quick and easy it is to configure backups and perform restores for VMware environments.
Getting started with customer-focused identity management
Learn why identity is a fundamental requirement to digital growth, and how without it there is no way to identify and engage customers in a meaningful way.
Reg Reader Research: SaaS based Email and Office Productivity Tools
Read this Reg reader report which provides advice and guidance for SMBs towards the use of SaaS based email and Office productivity tools.
Intelligent flash storage arrays
Tegile Intelligent Storage Arrays with IntelliFlash helps IT boost storage utilization and effciency while delivering unmatched storage savings and performance.
The next step in data security
With recent increased privacy concerns and computers becoming more powerful, the chance of hackers being able to crack smaller-sized RSA keys increases.