Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro slows down on subsequent runs
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? -- Regards; Rob ------------------------------------------------------------------------ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA macro runs fine, but freezes if I try to do ANYTHING else whileit runs | Setting up and Configuration of Excel | |||
One macro runs then it auto runs another macro | Excel Discussion (Misc queries) | |||
Code slows down after a few runs | Excel Programming | |||
Excel macro slows down on second run | Excel Programming | |||
Code slows on subsequent run | Excel Programming |