Unlike Microsoft Office 2008 for Mac NeoOffice 3 will handle the VB macros but I believe it does so by converting the VB macro to a NeoOffice/OpenOffice macro or at least I recall reading something about that once but I cannot find the reference at the moment. If Excel compatibility is not your primary concern you might take a look at NeoOffice Spreadsheets and their macro capability.

If you are patient, it appears the next Microsoft Office for Mac upgrade will once again offer VBA support but based on past performance I would not anticipate that support to be complete or fully functional.

If we knew what it was we were doing, it wouldn't be called research, would it?

— Albert Einstein