A co-worker of mine wrote a macro for me to take some data and re-organize it. He hasn't learned visual basic yet so he still writes macros on a template that originated in Excel 4 (Macintosh). He is running on a Bondi Blue (first edition) iMac that has OS 9 and Excel 98 on it. It is a G3 at not a lot of Mhz - maybe 200 or so?
I have a G5 dual 2Ghz processor with 2.5 GB RAM and OS X.
His macro takes 77 seconds to process 4000 odd lines of data on his Mac. On my Mac with Excel X it takes 3 minutes 44 seconds and with Excel 2004 it takes 7 minutes and 30 seconds. On somebody else's iMac G4 with OSX it takes about 4 and a half minutes. On our Citrix server version of Excel (PC) his computer takes 18 seconds to run it and mine takes 28 seconds.
What's the deal?????? We had to jump through hoops to justify getting me this big a$$ Mac and frankly it isn't much better than my G4 iMac was and worse for stuff like this.
Is there a utility somewhere that can convert his macro language into visual basic to hopefully run faster for me?
thanks in advance for any help.
Maureen
I have a G5 dual 2Ghz processor with 2.5 GB RAM and OS X.
His macro takes 77 seconds to process 4000 odd lines of data on his Mac. On my Mac with Excel X it takes 3 minutes 44 seconds and with Excel 2004 it takes 7 minutes and 30 seconds. On somebody else's iMac G4 with OSX it takes about 4 and a half minutes. On our Citrix server version of Excel (PC) his computer takes 18 seconds to run it and mine takes 28 seconds.
What's the deal?????? We had to jump through hoops to justify getting me this big a$$ Mac and frankly it isn't much better than my G4 iMac was and worse for stuff like this.
Is there a utility somewhere that can convert his macro language into visual basic to hopefully run faster for me?
thanks in advance for any help.
Maureen