speed up bulk changes/disable view update

[YZ]

Let me rephrase my question. What can be done to speed up
bulk modification on a Project using VBA?

It seems the views are constantly updating when the changes
are made. Is there a way to prevent Project from doing
anything till the large amount of data are populated.

Thanks.

 

[JackD]

The serializer which imports data is likely to be much faster than adding
all the tasks individually, so even though it is a workaround you might just
write all the tasks to a format which can be imported (excel, CSV etc.) and
then import it at one time using a predefined map.

Also, why not create the project once - then save it as a template and use
it whenever you need it.

-Jack

 

[YZ]

Thanks Jack. Your suggestion is definitely a legitimate
alternatives. Bulk changes such as import/export should be
done at the data layer. But for evaluation purposes on more
generic modifications through VBA or COM, I am still
courious about the speedup.

Yin