Insert tasks in a MSProject files via VBA

[Rorkidoky]

Hi,

I'm in charge to coordinate around 50 projects.
I use a MS project file to follow the governance meetings of these projects.
Each time that a new project is approved, I insert
- a task "execution"
- and 6 tasks with a SS predecessor of the "execution" with a lag of -x months (x depending on our governance rules).

I would like to run a macro, fill the execution date and then automatically insert (at the end of the project)the 7 new tasks linked.
Is it possible to do it with VBA code?

Any help appreciated,
Regards,

RK