Excess Memory Consumed when Running Macro in MSP 2002 Prof.

[Markus]

Dear all,

I have huge problems with insufficient RAM and virtual memory when running a
macro, which I developed, on large micosoft project plans (6000+ tasks) .

I built a Microsoft Project 2002 macro for the MSP client which copies
fields and sets the Outline level for all tasks is to 1.
The tasks are copied into other projects, and out of these projects I create
several master plans and save them on a MS Projectserver 2002.

While the macro is setting the Outline levels of the tasks to 1, the memory
usage of the MS Project Client greatly increases. After this process and
after a few small functions have been run through, the client randomly
hangs.
If the client doesn't hang, then some sequent VBA-functions are completely
skipped (like setting new values into Fields).
W2k also frequently runs out of virtual memory.

On plans with less tasks (ca. 2000) the macro works fine.

Does anybody know how to solve this problem?
Does anybody know if there is a possibility to free the consumed
(RAM/Virtual) memory without closing MS Project?

Thanx in advance,
Markus

 

[Rod Gill]

Hi,

How are you setting the outline level to 1? Try using outlineindent as one
method and resetting the column outline level to 1 in one go as another
method (this will be quickest).

--
Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/