Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with macros on Mac
I'm trying to use a worksheet that contains macros that a friend did on
his PC. They sheet's macros run fine on his and my PC, but they don't on my Mac running 10.3 and v.X. Any general ideas? Thanks in advance, Erik |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with macros on Mac
Here's a few:
1) All Mac VBA versions are 5.0 - equivalent to XL97's VBA, so methods introduced in VBA6 (like Replace, Join, Split, etc.) will not compile. However, there are workarounds for these. Search the micorosoft.public.mac.office newsgrops, or post back with specific problems: http://groups.google.com/advanced_gr...p:*mac.office* 2) ActiveX controls will not work on Macs as they are Windows-only technologies. Use the Forms controls instead. 3) There are a (very) few platform specific methods and properties that are unique to their respective platforms. It's unlikely this is your problem. One example is SendKeys, which doesn't work on Macs (which is a plus in my book!). 4) There are one or two syntax differences between platforms that are incompatible. For instance: GetOpenFileName method's FileFilter argument. I develop cross-platform all the time, using MacXLv.X - one technique I use all the time is conditional compilation - you can read about it in VBA Help. In article , "ErikW" wrote: I'm trying to use a worksheet that contains macros that a friend did on his PC. They sheet's macros run fine on his and my PC, but they don't on my Mac running 10.3 and v.X. Any general ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with Macros | Excel Discussion (Misc queries) | |||
Macros Problem | Excel Discussion (Misc queries) | |||
tough problem, maybe macros will solve it | New Users to Excel | |||
Problem Assigning Macros | Excel Worksheet Functions | |||
Problem with running Macros | Excel Discussion (Misc queries) |