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 |
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 |
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 |
All times are GMT +1. The time now is 09:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com