Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PC to MAC VBA function problem
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
PC to MAC VBA function problem
Did you try Tools/References and selecting VBA Project (Funcres) in the
VBE? In article .com, "cuboid" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
PC to MAC VBA function problem
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum function problem | New Users to Excel | |||
Problem with Function | Excel Worksheet Functions | |||
Problem With IF Function | New Users to Excel | |||
Function problem | Excel Discussion (Misc queries) | |||
if Function problem | Excel Discussion (Misc queries) |