Here is another article that shows how to do migrations of VBA code for Office to .NET and VSTO (Visual Studio Tools for Office). I highly recommend reading the article:
http://msdn.microsoft.com/office/default.aspx?pull=/library/en-us/odc_vsto2005_ta/html/OfficeVSTOExcelVBAMigration.asp
This is another proof point around the viability of automated Visual Basic Migrations.
Read on...