MacWindows.com recently polled readers on their willingness to upgrade to Office 2008 for Mac, which will not include Visual Basic for macros and automation (as noted on this MacBU developer blog). Several readers said they won't upgrade to 2008 because they depend on VB cross-platform support.
Where I work, we have an intricate system in place that manages and analyzes loads of data on a daily basis-a system that is dependent on homemade VB scripts. So, there's no way we're upgrading. Good job, Microsoft.
By the way, if you're left in a jam by this, check out MacTech Magazine's guide for moving from VB to Applescript, which will be available soon.