Mac Excel 2008: Macros?

I know this isn't directly programming related, but at the same time开发者_Go百科...

Mac Excel 2008 doesn't support VBA or Macros... which I need for a class...

Does anybody know of a solution? I need a way to write simple macros on Mac in Excel-- if it's possible.

Please don't give vague answers if you don't know for sure. This is a serious question. :)

If you really need to write proper macros, you're SOL with 2008 and would be better off finding a copy of 2004 or Office for Windows. If you just need to write code to control the app, Microsoft's suggested replacement for macros in Mac Office is the native Applescript.

If you're into archeology, Mac Excel 2008 supports XLM macros (a.k.a Excel 4.0 macros). You'll have a hard time finding relevant documentation about XLM, as it appears to have gone out of fashion many years ago. You can create a sheet macro through the "insert sheet" wizard (there's a Excel 4.0 Macro Sheet option).

Then you can download the docs from Microsoft: link.

Here's a simple one:

IsFormula<br>
=ARGUMENT("aCell",8)<br>
=RETURN(GET.CELL(48, aCell))<br>

You can then use the macro in a formula, e.g. =IsFormula(A1)