So slow Macro's

[Paul Skinner]

Simple speed test on : - Excel 10.1.6, Tiger, imac g5 1.8, 1 Gig ram, !142
secs!. Excel 2004, Tiger, Power Mac dual 2.3, 1 Gig ram 19 secs.
Pentium 3, Windows 97. Excel 97, 256meg ram 9.6 secs. Then bosses new
toshiba laptop, windows xp pro, excel 2003, 2.6 secs. Mine is the imac
--Same result at Apple store on an imac. Any Thoughts or Answers why?
Ran this test from John Walkenbach Power programing book.
Sub TimeTest()
Dim x As Integer, y As Integer
Dim A As Integer, B As Integer, C As Integer
Dim i As Integer, j As Integer
Dim StartTime As Date, EndTime As Date
' Store the starting time
StartTime = Timer
' Perform some calculations
x = 0
y = 0
For i = 1 To 5000
For j = 1 To 5000
A = x + y + i
B = y - x - i
C = x - y - i
Next j
Next i
' Get ending time
EndTime = Timer
' Display total time in seconds
MsgBox Format(EndTime - StartTime, "0.0")
End Sub
Paul

 

[Bob Greenblatt]

Well, I get 28 secs on a 1.5GHz G4, Excel 2004; and 7.5 secs on a 1.6GHz P4
with Excel 2003. Macro execution is just slower on a Mac than on Windows.

On the Mac I changed the Integer declaration to double and got 33 secs., and
31 secs as Long.

 

[Bernard Rey]

On a Dual 867 MDD G4, 1 GB, Mac OS 10.3.9:

- Excel 2003 / Windows XP/ Virtual PC 7: 22.8 s
- Excel:2001 (in Classic): 23.0 s
- Excel 97 / Windows 98SE / Virtual PC 7: 28.8 s
- Excel 2004: 53.0 s
- Excel v.X: 192.0 s

But that's (unfortunately) nothing new. It has been said already, and it's
quite amazing how Excel in Virtual PC can run macros faster than natively in
a Mac version. Or that Excel:2001 in Classic (another emulation, in fact)
does it faster than the newer versions. But well that's how it is...

Let's say the good point is that Excel 2004 does run it (much) faster than
Excel v.X. We can hope further versions may improve that.


Bob Greenblatt: