PC to MAC VBA function problem

[cuboid]

I have a PC spreadsheet with some VBA macros that won't compile on a
Mac with Office 2004. Spreadsheet was written with Excel2000 on a Win2K
machine.

he compile error is about a missing library, and it's looking for
FUNCRES.XLA. I have the Analysis ToolPak loaded (which, on the Mac, has
FuncRes, without any extension) and it still won't compile.

Is there a workaround/fix for this or are we doomed to not being able
to share spreadsheets from PCs to Macs?

thanks
CB

 

[JE McGimpsey]

Did you try Tools/References and selecting VBA Project (Funcres) in the
VBE?

 

[cuboid]

Aha! Thank you - that seems to make the compiler happy now. The
spreadsheet project in question still says FUNRES.XLA is missing, but
the VBA Project (Funcres) now shows it knows where Analysis Tools - VBA
is.

(Now that it compiles and loads ok, I can see why some of the function
calls seem to be unhappy in the project..the programmer who did the
spreadsheet is getting me another version to check out on the Mac
today..)

thanks,
cb