Macro VBA Speed

[esailor]

We are using MS Word as texteditor on Mac & Windows and we fill our
documents with contents of a database runing VBA.
This is slow on Mac comparing to Windows.
But with Office 2004 (update 11.1) our Macros are again slower than
with Office X.

Unbelievable, I think Bill really tries hard to move all Office User
over to Windows.

Any experience with that problem?
Thanks for any helpful suggestions

best regards
karl bauer

 

[JE McGimpsey]

We are using MS Word as texteditor on Mac & Windows and we fill our
documents with contents of a database runing VBA.
This is slow on Mac comparing to Windows.
But with Office 2004 (update 11.1) our Macros are again slower than
with Office X.

Unbelievable, I think Bill really tries hard to move all Office User
over to Windows.

Any experience with that problem?

It's hard to make a substantive comment without seeing your code.

I haven't seen any slowdown between X and 2004. Can you tell what part
of the macro is slower?

 

[John McGhie]

Yeah, I am with John on this one: Let's see your code and we can probably
spot the problem for you.

Word 2004 is not noticeably slow in VBA with the service pack. But it does
slow down a lot in VBA if you do not have enough memory available.

Word drags large lumps of data across the system bus: it will be noticeably
slower on the Mac because you are dealing with a 133 MHz system bus compared
to 800 MHz.

But good VBA code design will help a LOT

We are using MS Word as texteditor on Mac & Windows and we fill our
documents with contents of a database runing VBA.
This is slow on Mac comparing to Windows.
But with Office 2004 (update 11.1) our Macros are again slower than
with Office X.

Unbelievable, I think Bill really tries hard to move all Office User
over to Windows.

Any experience with that problem?
Thanks for any helpful suggestions

best regards
karl bauer

--

Please reply to the newsgroup to maintain the thread. Please do not email
me unless I ask you to.

John McGhie <[email protected]>
Consultant Technical Writer
Sydney, Australia +61 4 1209 1410

 

[Paul Berkowitz]

Word drags large lumps of data across the system bus: it will be noticeably
slower on the Mac because you are dealing with a 133 MHz system bus compared
to 800 MHz.

Not all Macs. My Dual 2.0 G5 has a 1 GB Bus Speed. Definitely not slow in
Word or anywhere else.

But good VBA code design will help a LOT

For sure. But I'd guess that you were right to begin with, and Karl's Mac
might be low on RAM, as well as bus considerations.


--
Paul Berkowitz
MVP MacOffice
Entourage FAQ Page: <http://www.entourage.mvps.org/faq/index.html>
AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/>

Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.

PLEASE always state which version of Microsoft Office you are using -
**2004**, X or 2001. It's often impossible to answer your questions
otherwise.