Running an excel macro on a Mac

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tobyyoungsj3@aol.com - 14 Jul 2007 14:55 GMT

I purchased Office 2004 student and teachers edition so that I could
do some course work online. The problem I am running into is the
course has several Excel templates that have macros and I can't seem
to run the macros. I get the following error message when I try to
open the template;

"You are using Microsoft Excel version 11.3, this template will not
function with this version of Excel. You need to use Excel 2002/Excel
version 10.0 or higher."

Also, when I did open one template, I got this message; "compli error
in hidden module: module 1".

I am not sure what approach to take to get the templates to work
right.

Thanks for any help

Reply to this Message

JE McGimpsey - 15 Jul 2007 06:03 GMT

> I purchased Office 2004 student and teachers edition so that I could
> do some course work online. The problem I am running into is the
[quoted text clipped - 11 lines]
> I am not sure what approach to take to get the templates to work
> right.

Sounds like the templates run an internal macro to check the version,
and when it's not what it expects (either because it's running on a Mac
or because the template stupidly doesn't accept a higher version, e.g.,
11, than it's designed for). Not much you can do other than (a) rewrite
the macro if it's unprotected, (b) ask the developer to change the
macro, or possibly (c) if you can still use the template without the
macros, open the file with the shift key down.

The compile error is probably due to using a VBA6 command, which exists
in XL2002, but not in any Mac version.

Reply to this Message

Mac Forum / Applications / Excel / July 2007

Running an excel macro on a Mac