Running an excel macro on a Mac

[tobyyoungsj3]

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

 

[JE McGimpsey]

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.

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.