A while ago I presented a session on developing Office based solutions at several Microsoft "Heros Happen Here" launch events in the Mid-Atlantic region. One topic I touched briefly was Visual Studio 2008's support for VBA via interoperability service. There is a great introduction article on the topic at MSDN that I'd like to recommend, VBA Interoperability with Visual Studio Tools for the Office System (3.0). This new feature is currently available for Microsoft Office Excel 2007 and Microsoft Office Word 2007.