Mac Excel 2008: Macros?

Question

I know this isn't directly programming related, but at the same time...

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. :)

That's what I'm finding out! :( – Kevin Brown Jan 12 '10 at 19:44 — Kevin Brown, Jan 12 '10 at 19:44

score 1 · Accepted Answer · answered Jan 12 '10 at 19:28

1

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.

answered Jan 12 '10 at 19:28

Chuck

234,037
30
302
389

I'm assuming that Applescript is essentially a different language compared to VBA? This class is VBA-specific... – Kevin Brown Jan 12 '10 at 19:44
Yeah, Applescript is quite different from VBA. There's no VBA support at all in Excel 2008, unfortunately. – Chuck Jan 12 '10 at 19:54

score 1 · Answer 2 · edited Oct 28 '11 at 19:32

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)

Mac Excel 2008: Macros?

2 Answers2