macro slows down

[Gary Keramidas]

just wondering if anyone has seen this
this happens in all cases, but here is an example:

i loop through about a dozen workbooks, opening, copying some data to a
report workbook, and closing it.
if i load the report wb and run the macro, it takes maybe 3 seconds to
complete.
once i load the vb editor and close it, it takes about 7 seconds. so, this
is not run when the vb window is open.
closing the workbook and re-opening it doesn't speed it up, only closing
excel and running the macro before opening the vb editor speeds it up.

only have 5 references in vba:
vba
excel 11 obj lib
ole automation
office 11 obj lib
ms forms 2.0 obj lib

any ideas?

 

[Gary Keramidas]

does anyone have any ideas on this? i load 42 sheets and import some data.
takes 6 seconds. after i open and immediately close the vbe, it takes 14
seconds. and it takes that long until i close excel and load it again. then
it takes 6 seconds again.

seems weird to me.