MICROSOFT OFFICE FOR MAC

[Chris72]

I have been using MS Excel for many years and still do at work. I regularly use "Array Calculations" and sometimes use Macros written in Visual Basic. Neither of these capabilities are available in Numbers. I also understand that Visual Basic is unavailable in MS Office for Mac 08. Does anyone know if Visual Basic is available in MS Office for Mac 04? If not I will stick with Numbers and the occasional use of Open Office.

 

[Jim Gordon MVP]

I have been using MS Excel for many years and still do at work. I regularly use "Array Calculations" and sometimes use Macros written in Visual Basic. Neither of these capabilities are available in Numbers. I also understand that Visual Basic is unavailable in MS Office for Mac 08. Does anyone know if Visual Basic is available in MS Office for Mac 04? If not I will stick with Numbers and the occasional use of Open Office.

Hi,

Visual Basic is available in Office 2004 (but not 2008) on the Mac.
Array calculations are supported.

NeoOffice has visual basic, but arrays are not fully supported in their
implementation of VBA.

-Jim

 

[JE McGimpsey]

I have been using MS Excel for many years and still do at work. I regularly
use "Array Calculations" and sometimes use Macros written in Visual Basic.
Neither of these capabilities are available in Numbers. I also understand
that Visual Basic is unavailable in MS Office for Mac 08. Does anyone know if
Visual Basic is available in MS Office for Mac 04? If not I will stick with
Numbers and the occasional use of Open Office.

Yes, XL04 supports VBA.