So, I've got a wall of Microsoft Office books dating back to Excel 5.0. (My MS-DOS manuals like Wordstar, Paradox and Lotus Symphony made it to the garage). I have several editions of VBA / Access books dating back to the Four Amigos (Getz, Gilbert, Gunderloy, Litwin). I've the Eric Wells Excel VBA classics. And the Woody Leonhard Word tomes as well. I resisted buying a lot of paper for Office 2002, 2003. But with Office 2007, I've got to give in. There's so much gifting of new features and architecture in this new version, I broke down and spent some money.
Word 2007 Inside Out (Microsoft Press) is a change from the plodding, grey suited bricks. It gives more detail than I could find in Help on Quick Styles and Style / Theme management.
VBA and Macros for Microsoft Office Excel 2007 by Bill Jelen and Tracy Systrad seems very readable and full of insights. I have not come across the Excel 2007 VBA Programmer's Reference by Green, Bovey, Bulleen, Alexander - but the older edition was a keeper.
The ranks of the veteran Microsoft Access authors have been decimated. Gunderloy has gone Rails, the others may have ascended to dot Net. This new book - Access 2007 VBA Programmer's Reference is by names I am not familiar with - Hennig, Cooper, Griffith & Stein. The selection of topics looks good.