Here's a link to a MacWorld article regarding Office for Mac 2008 (due out later this year) dropping support of VBA. However, VBA code can be rewritten in AppleScript and a new guide to help users make the transition will become available in April.

http://www.macworld.com/weblogs/edit...uide/index.php

Hope this helps,
theDude