Re: PC to Mac macro speed issues

I have just installed excel on my Mac (after much deliberation about
whether
it would be worth the effort)

Macros that work on the pc don't work on the Mac

Macros that do work on the Mac take an incredibly long time to run

Then I find out I now have to pay for an odbc driver in order to query
external spreadsheets and databases

I am very very disappointed

Love the Mac for all the unim****tant stuff but will be returning to the
windows environment for my work-related matters


On 11/5/07 2:00 AM, in article
1178812807.081066.123240@[EMAIL PROTECTED]
 "robotman"
<robotman@[EMAIL PROTECTED]
> wrote:

> 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
>