This is my VSTO page. Here I link to some of the resources I use for working with Visual Studio Tools for Office. Plus a few links to Office Business Applications (OBA) items of interest. I also blog about VSTO (you can view the VSTO posts here) or subscribe to the feed: VSTO feed
A short history of VSTO
VSTO is Microsoft’s tool set for building applications that run in Microsoft Office (eg Word, Excel, Outlook, PowerPoint).
Originally a replacement for VBA (Visual Basic for Applications) that was delivered in Excel and Word, VSTO was made available in its first version approximately around the start of 2004, targeting the Office 2003 platform. Development was performed in Visual Studio 2003 but was referred to as VSTO 2003 (or sometimes VSTO 1.0). It was an add-on to VS.NET 2003 and wasn’t free (costing around $450).
The second version, referred to as VSTO 2005 was a big update that added numerous advances and enhancements (eg support for Outlook). It was delivered as a special SKU of VS 2005 (my understanding is it was not available as a separate download, but I could be wrong).
The third version, confusingly titled VSTO 2005 Second Edition (VSTO 2005 SE) was delivered in 2007 and focused on targeting the Office 2007 platform. It was a freely downloadable add-on for VS 2005.
This SE version was tweaked significantly and included as part of Visual Studio 2008 (released in November 2007), and is referred to as VSTO V3 (even though it is the fourth version of the product). VSTO 2008 overcomes many of the deployment and security hurdles found in previous versions, and adds a number of design helpers (eg visual editing of Office 2007 toolbars, support for SharePoint 3.0 Workflow, etc).[The reason the version numbers are confusing is because in Vx terms they refer to the runtime used, not so much the tooling released. So, technically speaking VSTO 2005 and VSTO 2005 SE both use the same V2 runtime. VSTO in Visual Studio 2008 is using V3 of the runtime, even though it is the fourth release of the product.]
The aim of VSTO is to provide tools for developers to build on top of Office as a platform. Using VB.NET and/or C#, developers can use Visual Studio to build add-ins for most of the Office 2003 and 2007 applications, including Word, Excel, Outlook, PowerPoint, InfoPath and Visio. SharePoint and Groove development is also possible, although not directly targeted.
I personally believe the time for VSTO has come. I say this for two reasons:
- Because the Office platform is now at a point where it is not only feature rich, but easily scalable as a platform (especially via it’s SharePoint strategy).
- VSTO has a comprehensive feature set, and has addressed many of the deployment and security aspects that hindered it predecessors.
Trivia: Was originally pronounced ‘visto’ but was discouraged once Vista came out in order to reduce the confusion between them in casual conversation. Lately ‘visto’ has re-entered ‘accepted’ conversation :-)
VSTO on MSDN
Office Zealot – VSTO
Outlook Code and Forum
Ken Slovak (Outlook)
Office Business Applications Developer Portal
Office Business Applications FAQ
Office Business Applications Case Studies
See here for my full list of OBA resources
VSTO Blog (this includes Mary Lee and Christen Boyd posts)
John R Durant
Kris Makey (focuses on deployment)
Nikhil Khandelwal (focuses on SharePoint workflow and VSTO)
OBA Team Blog