Feeds

VSTO For Mere Mortals

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

Securing Web Applications Made Simple and Scalable

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)!

Bridging the IT gap between rising business demands and ageing tools

More from The Register

next story
NO MORE ALL CAPS and other pleasures of Visual Studio 14
Unpicking a packed preview that breaks down ASP.NET
Secure microkernel that uses maths to be 'bug free' goes open source
Hacker-repelling, drone-protecting code will soon be yours to tweak as you see fit
KDE releases ice-cream coloured Plasma 5 just in time for summer
Melty but refreshing - popular rival to Mint's Cinnamon's still a work in progress
Cheer up, Nokia fans. It can start making mobes again in 18 months
The real winner of the Nokia sale is *drumroll* ... Nokia
Put down that Oracle database patch: It could cost $23,000 per CPU
On-by-default INMEMORY tech a boon for developers ... as long as they can afford it
Another day, another Firefox: Version 31 is upon us ALREADY
Web devs, Mozilla really wants you to like this one
Google shows off new Chrome OS look
Athena springs full-grown from Chromium project's head
prev story

Whitepapers

Designing a Defense for Mobile Applications
Learn about the various considerations for defending mobile applications - from the application architecture itself to the myriad testing technologies.
Implementing global e-invoicing with guaranteed legal certainty
Explaining the role local tax compliance plays in successful supply chain management and e-business and how leading global brands are addressing this.
Top 8 considerations to enable and simplify mobility
In this whitepaper learn how to successfully add mobile capabilities simply and cost effectively.
Seven Steps to Software Security
Seven practical steps you can begin to take today to secure your applications and prevent the damages a successful cyber-attack can cause.
Boost IT visibility and business value
How building a great service catalog relieves pressure points and demonstrates the value of IT service management.