The Cost of the Intel Transition
I wouldn't get worked up about losing VBA.
If you need the latest and greatest from Microsoft it will be more important that you can get MS Server 2003 running via Parallels. Then run Office12 from there.
The Leopard preview really reinforces the pattern we've been seeing from Apple for the past view...
Right now, August 2006. ADO (the VBA library for executing SQL) is not available for MS Office 2004.
So Office for Mac has been more of a document reader than a development tool and it's been like that for years. Even MS Access has never been available for Mac.
Server 2003 is important because MS has been spending a lot of money on IIS and Sharepoint and 2003 has integrated operating sytem and Sharepoint "built in" if you install it. MS is giving away Sharepoint and IIS to all it's Gold Partners - all the big comanies that have support contracts with MS.
Once we get into 2008 and 2009, you're gonna be in FAT city if you have 2003 or 2007 running under Parellels. And you'll be totally out of luck if you don't.
The only thing that OS X truely lacks is native support for WMV and other video formats. If the Microsoft team focused on that I'd be happy. Delighted!