PC to MAC VBA function problem

C

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
 
C

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top