macro slows down

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

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.

--


Gary


"Gary Keramidas" <GKeramidasATmsn.com> wrote in message
news:[email protected]...
> 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
>
>
>