There's a fairly good article on some of the key points of Office 2007's programmability experience at http://www.adtmag.com/article.aspx?id=18978

I don't directly work on this at Microsoft, but have been following it more as a user. I am really interested in the notion of a "business data catalog". The interviewee talks a little bit about this specifically:

The major advance there is