Forum Discussion

pascalito's avatar
pascalito
Copper Contributor
Feb 07, 2022

Comment remplacer une ressource par une autre en VBA

Bonjour,   J'ai un problème fort simple, mais que je n'arrive pas à résoudre en VBA.   J'ai une ressource, on va dire Toto  J'ai une autre ressource, on va dire Tutu   Je voudrais transférer l...
  • pascalito's avatar
    pascalito
    Feb 10, 2022

    John-project 

     

    Thanks for your help, I've tight schedule to respect, and have no time for translating and editing code to make it smaller.

    I guess, I'll have to take another approach that is less tedious, althought it might require much more manual editing.

John-project's avatar
John-project
Silver Contributor
pascalito,
You're welcome and thanks for the feedback. Sorry I couldn't have offered more help.
John
pascalito's avatar
pascalito
Copper Contributor
Feb 11, 2022

John-project 

 

Ultimate update

 

1. There was an error in the code logarithm, the transfer was assumed to go from assignment start (affect.Start) date until the resource change takes effect (Effectif), regardless of the assignment finish date. Therefore, it took very long since we carry over 2018 assignments, which meant 1400 itérations where ca. 40 were required.

 

2. Optimizing the transfer using .Value, tsv.Value = oldTsv.Value instead of tsv = oldTsv.Value

 

3. The type of task also impacts the performance, effort driven fixed duration tasks. vs fixed units not effort driven

Althought it is not achieved in a flash, I managed to process 15 projects in an hour, which is acceptable.

Resources