Same problem when I tried StarOffice (Sun Microsystems) - I need macros and
VB.
I do think that MSFT's lock on the desktop will erode over the next 5 years. And I would like to see Apple port one of these open source office suites to Mac OS as a hedge against MSFT dropping Office X - in fact I'm sure they've already done it, internally, since it should be pretty easy with OS X.