Word VBA performance and file size question.

[BillW]

We have a VBA app running on Word XP that just started to run much slower in
our latest release.

We didn't change anything in the VBA app that would account for this speed
difference. The only thing we noticed is that the new file (a DOT) is much
smaller than the old (faster) DOT file.

Are there compile options in VBA that might account for the size and speed
difference?

Thanks!

wolfereeno at yahhoo dot com

 

[Howard Kaikow]

We have a VBA app running on Word XP that just started to run much slower in
our latest release.

We didn't change anything in the VBA app that would account for this speed
difference. The only thing we noticed is that the new file (a DOT) is much
smaller than the old (faster) DOT file.

Are there compile options in VBA that might account for the size and speed
difference?

You did change something, so that could be the cause. There are many subtle
factors affecting speed.
Not to mention other apps, etc.

 

[BillW]

You did change something, so that could be the cause. There are many
Such as?!

No code or functionality was removed. Only a slight addition to a complete
unlrelated function. What kinds of things could account for the file
becoming smaller AND slower?

 

[Howard Kaikow]

Such as?!

No code or functionality was removed. Only a slight addition to a complete
unlrelated function. What kinds of things could account for the file
becoming smaller AND slower?

ANY change you make affects the size and speed.

 

[BillW]

ANY change you make affects the size and speed. <<

Thank you Captain Obvious.


For others lurking, perhaps something along these lines would be more
helpful. We haven't tried it yet but it looks promising.
http://archive.baarns.com/excel/develop/vbaperfm.asp

 

[Howard Kaikow]

Thank you Captain Obvious.

That should be Oblivious.