Adding a Task in MS Project at a specific location with VBA through Excel

Question

I have and Excel file with all current tasks. New tasks maybe be added at any position. I want to update my MS Project file from Excel by adding missing tasks. Using .Tasks.Add("name from Excel") will as a new Task in MS Project at the bottom. How can i add new Task at a specific location in the middle using VBA from Excel? Can I use SelectRow and InsertTask in VBA code from Excel somehow?

*EDIT Forgot to mention, .Tasks.Add does not let me use a 2nd argument, like it says in documentation.

With mpp
    .Tasks.Add ("name from Excel", RowNumber)
End With

This code will have the line with .Tasks.Add ("name from Excel", RowNumber) in red. If i remove the 2nd argument, it's fine and works.

Rachel Hettinger · Accepted Answer · 2022-03-24 20:10:28Z

1

A quick check of the docs for Tasks.Add shows that the method takes an optional second argument Before:

The position of the task in its containing collection. The default value is the position of the last item in the collection. (data type Long)

Utilize the second argument and pass in the ID of the task before which the new task should be added. For example:

With mpp
    .Tasks.Add "name from Excel", RowNumber
End With

Or

Dim t As MSProject.Task
With mpp
    Set t = .Tasks.Add("name from Excel", RowNumber)
End With

edited Mar 24, 2022 at 20:10

answered Mar 24, 2022 at 16:07

Rachel Hettinger

8,4872 gold badges25 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Ale Over a year ago

Oh yes, i forgot to mention. It does not let me add a 2nd argument like that. Text becomes red in VBA.

Rachel Hettinger Over a year ago

Remove the parentheses since you aren't returning an object. I updated my answer based on your code update.

Ale Over a year ago

Thank you very much Rachel. I tried both your solutions and both do exactly what they need to.

Collectives™ on Stack Overflow

Adding a Task in MS Project at a specific location with VBA through Excel

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related