VBA to VSTO

A recurring topic these days: to customize Project Professional 2007 should I be using VBA or VSTO?

Jack Dahlgren has just published a great post on the subject: Making the move from VBA to VSTO in Microsoft Project highlighting two benefits of switching to VSTO:

1. ClickOnce deployment

ClickOnce deployment allows you to publish Windows-based applications to a Web server or network file share for simplified installation. Visual Studio provides full support for publishing and updating applications deployed with ClickOnce.

1. Improved Visual Studio 2008 template for building a Project Add-in

Other interesting articles worth reading on pros/cons of making the transition are:

• Converting Code from VBA to Visual Basic .NET
• Migrating a VBA Solution to a Visual Studio Tools for Office Add-In