Quote Originally Posted by BlueCactus
Half the reason I haven't been on the site much is that I'm getting tired of all the cross-platform issues with VBA. For example, I can't test most of the KBs at home because they rely either on VB6 or ActiveX.
Know the feeling well.

Will they ever port VB.NET or VB 2005 or whatever they're calling it these days?
From all that I have read, MS will not port anything remotely connected to VBA's replacement.

Without a scripting language built into Office that runs on both platforms, I no longer have a fundamental reason to stick with Office.
I suspect that will be true across the board. Nisus Writer Express and Mellel can handle most Word documents. Mesa, Mariner Calc, and icExcel can provide most of the strict spreadsheet functionality and interchange of Excel. And of course, there is the OO port to Mac OS X, NeoOffice. I have it, used it briefly for word processing. Now I might consider its spreadsheet module.

Here are a couple of high end statistical and data analysis tools that might prove useful:

Aabel 2 from Gigawiz.

Quantrix for modeling purposes.