It has been sometime since there is an issue of MSDN mag that focuses on Office Business Application development. I believe not since before Visual Studio 2008 released. Visual Studio 2008 does comes with a lot of new tools inside VSTO for OBA development and it is worth while to have a look what you can achieve easily here.

Editor’s note on why one should think of Office as a development platform http://msdn.microsoft.com/en-us/magazine/cc507637.aspx

Document Automation using VBA to VSTO
http://msdn.microsoft.com/en-us/magazine/cc507643.aspx

Automate Web App Deployment with the SharePoint API
http://msdn.microsoft.com/en-us/magazine/cc507633.aspx

Integrate VSTO with SharePoint Content Types
http://msdn.microsoft.com/en-us/magazine/cc507632.aspx