If anyone else is using Office 2004 for that reason, here's a thin shard of hope for you. This week, Microsoft's Office for Mac Team announced that mainstream support or Office '04, scheduled to end on October 13, 2009, will be extended through January 10, 2012.
Why extend support? As the blog post notes, Visual Basic support will return in the next major release of Office for the Mac, scheduled to hit the stands in 2010. This way, folks reliant on VB will be able to hold on until that new release is available. This is good news for anyone who was wondering how to migrate from a slew of mission-critical scripts.