If you’re an advanced user of Office 2007, or maybe you want to test your Office 2007 skills, don’t forget about the upcoming contest starting April 20. As mentioned here http://blogs.msdn.com/microsoft_press/archive/2009/04/01/advanced-2007-office-system-user-a-contest-for-you.aspx
The contest features ten fun VBA coding challenges in the form of puzzles and games. Each entrant will earn a chance to win one of hundreds of available prizes, determined by a random drawing at the end of the contest.
There are also some additional articles from Microsoft Press book Advanced Microsoft Office Documents 2007 Edition Inside Out now available to help you prepare.
Troubleshooting Word 2007 Documents More Easily Using VBA: http://msdn.microsoft.com/en-us/library/dd630112.aspx
Using VBA to Access Document Content in the 2007 Office System: http://msdn.microsoft.com/en-us/library/dd630624.aspx