deleting tasks

T

Tomcat

I am importing data from Access to Project with outline levels for the
different tasks. Because of the generalities of my Access database, I
sometimes will have a summary task, outline level 1, with no subtasks,
outline level two. I know I could go in and delete these by hand but my file
is around 10,000 tasks and this would take too long. Is there away I can
automate this deletion process. For example, press a button that would
delete all tasks with outline level one without summary tasks underneath
them. I don't want to filter a view because the "summary tasks" with no
subtasks still affect my overall project percent complete and so on. Thanks
for your help.
 
J

JackD

If the tasks are truly unnecessary then filter before you import.
It is fairly trivial to write a macro to delete these tasks.

Sub tomcat()
Dim t As Task
For Each t In ActiveProject.Tasks
If t.OutlineLevel = 1 And t.OutlineChildren.Count = 0 Then
t.Delete
End If
Next t
End Sub

You can assign the macro to a toolbar button.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top