R
RWN
XL'03 on XP.
I have a macro (template) that opens three workbooks and compares one to the other two and
puts out a list of inconsistencies on a separate sheet.
The macro runs great (fast) on the first call but slows down (an incredible amount) when
called again.
Having been hit by memory leaks in prior versions of XL I ensured that I set all my
objects to nothing, closed the open workbooks, suspended the screen updating etc.. All of
which to no avail.
The only difference is that on subsequent calls I delete the output sheet & create a new
one prior to processing the workbooks.
I have to not only close the workbook but *close Excel* in order for the macro to work
properly.
There are no graphics (save for a form button that calls the macro) and it is run on a
local machine (no network drives).
Any hints?
I have a macro (template) that opens three workbooks and compares one to the other two and
puts out a list of inconsistencies on a separate sheet.
The macro runs great (fast) on the first call but slows down (an incredible amount) when
called again.
Having been hit by memory leaks in prior versions of XL I ensured that I set all my
objects to nothing, closed the open workbooks, suspended the screen updating etc.. All of
which to no avail.
The only difference is that on subsequent calls I delete the output sheet & create a new
one prior to processing the workbooks.
I have to not only close the workbook but *close Excel* in order for the macro to work
properly.
There are no graphics (save for a form button that calls the macro) and it is run on a
local machine (no network drives).
Any hints?