Which is more efficient? Search and Replace or Looping Through AllProject Tasks?

[anovak]

During testing, it seems about the same, but generally speaking is it
more efficient or "better" to do a search and replace (within VBA) on
project task contents or loop through each task via VBA and set the
values individually?

Thanks,
Andy Novak
UNT

 

[Ben Howard [MVP]]

Hi Andy,
for a full answer post this to the developer newsgroup. However, in Rod
Gill's book he publishes a piece of code that allows you to time the
execution of some VBA, but I would say, unless you have thousands of tasks in
a project, then it really doesn't matter which way you do it.

 

[anovak]

Hi Andy,
for a full answer post this to the developer newsgroup.  However, in Rod
Gill's book he publishes a piece of code that allows you to time the
execution of some VBA, but I would say, unless you have thousands of tasks in
a project, then it really doesn't matter which way you do it.

Yeah, I forgot to post to the developer Newgroup. I may put this over
there.