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]

In article <341ce999.04111...@posting.google.com>,
k.b...@uhrwerk.com (esailor) wrote:

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

On 19/11/04 6:32 AM, in article
341ce999.04111...@posting.google.com, "esailor"
<k.b...@uhrwerk.com> wrote:

--

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

John McGhie <jo...@mcghie.name>
Consultant Technical Writer
Sydney, Australia +61 4 1209 1410

[Paul Berkowitz]

On 11/21/04 11:35 PM, in article BDC7E1F4.D290%jo...@mcghie.name, "John
McGhie" <jo...@mcghie.name> wrote:

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