Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PC to Mac macro speed issues
I'm writing a macro that needs to run on a PC and Mac.
I have the code working on both platforms, but the Mac is incredibly slower. What takes 20 seconds on a PC takes over 12 minutes on the Mac! Another thing that takes 1 second on the PC, takes over 2 minutes on the Mac. The Mac is a new MacPro. Most of the macro is dealing with transfering information from one spreadsheet to another and formatting cells. * Can anyone help me understand the speed difference and if there are any tricks to speed up the Mac? (any webpages dedicated to this issue?) Thanks. John |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
PC to Mac macro speed issues
Hi John.
I do not use a Mac and cannot help you with your problem. It may, however, be advisable additionally to address your question to the corresponding Mc NG: microsoft.public.mac.office.excel --- Regards, Norman "robotman" wrote in message ups.com... I'm writing a macro that needs to run on a PC and Mac. I have the code working on both platforms, but the Mac is incredibly slower. What takes 20 seconds on a PC takes over 12 minutes on the Mac! Another thing that takes 1 second on the PC, takes over 2 minutes on the Mac. The Mac is a new MacPro. Most of the macro is dealing with transfering information from one spreadsheet to another and formatting cells. * Can anyone help me understand the speed difference and if there are any tricks to speed up the Mac? (any webpages dedicated to this issue?) Thanks. John |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
PC to Mac macro speed issues
The Mac forum didn't necessarily programming related so I thought this
forum might be more appropriate, but I will also post there to see what response I get. Thanks. John |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
PC to Mac macro speed issues
Can't give you an exact answer, but maybe add some timing code (similar to
that outline in help, under "ScreenUpdating Property"), to narrow down the problem area, if it exists. Certain aspects of Excel work differently (or not at all) on a Mac compared to a PC, so may depend on what you are doing. There is the compiler direction "Mac": #If Mac Then #Else #End If so you can include/exclude certain code depending on the platform, if you find different ways are needed/better depending on the platform. NickHK "robotman" wrote in message ups.com... I'm writing a macro that needs to run on a PC and Mac. I have the code working on both platforms, but the Mac is incredibly slower. What takes 20 seconds on a PC takes over 12 minutes on the Mac! Another thing that takes 1 second on the PC, takes over 2 minutes on the Mac. The Mac is a new MacPro. Most of the macro is dealing with transfering information from one spreadsheet to another and formatting cells. * Can anyone help me understand the speed difference and if there are any tricks to speed up the Mac? (any webpages dedicated to this issue?) Thanks. John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
More Excel 2007 Speed Issues | Excel Programming | |||
Speed issues | Excel Worksheet Functions | |||
How to speed up this macro? | Excel Programming | |||
Speed up macro | Excel Discussion (Misc queries) | |||
Speed Issues again | Excel Programming |