Slow Execution speeds for repeated VBA code in Project

[popper]

Hi,

I am desperate for some help. I have VBA code that processes 80 high-level phases or WBS elements, each consisting of 40 rows, within the Microsoft Project task list. It takes about 75 seconds to process EACH of these phases when they are assembled in one file, which is incredibly slow. However, when there is only one phase in the file, that phase takes about half a second - which is what I was expecting as an average for all of them. I cannot understand why the presence of other phases should have effect on the execution speed of any particular one.

As far as I can tell the code is pretty tight. There are no big loops that traverse the entire list - which would explain the problem. It is a complete puzzle to me.

I would appreciate any assistance anyone can provide.

Thank you

 

[PDQBach]

The code you provided looks fine to me. I don't see any errors. I don't see any glaring issues.

This seems to me like an excellent opportunity to ask for an upgraded, more powerful PC.