I added timing to the inner guts of the program
Witrh Screenupdating disabled, time was 3943 milliseconds.
With Screenupdating enabled, time was 4833 milliseconds, that's one heck of
a
relative performance hit!
Both of the above were run from the VBIDE.
I compiled the
VB 6 code, time to run was 3924 millisconds.
Excel is not visible in all cases.
Perhaps a silly question, but is there "documentation" of how a disabled
Screenupdating affects non-visible documents?
Oh well, a few daze ago the code was taking over 50 seconds.