delete certain tasks macro

[Tomcat]

How would I write a macro that would delete all tasks with duration = 1 day.
I have around 10,000 tasks so writing a macro is necessary unless Project
already has this functionality built in. I have never written a macro before
so any help would be appreciated.

 

[Rod Gill]

No need for a macro:

Save a copy of the file
Select Project, Filtered For, More Filters
Create a new filter called Duration1 that shows only tasks with a duration
of 1d
OK then Apply

You should now only see tasks with a duration of 1d so you can delete them
all in one go.
Shortcut to show all unfiltered tasks again is to press F3

 

[John]

How would I write a macro that would delete all tasks with duration = 1 day.
I have around 10,000 tasks so writing a macro is necessary unless Project
already has this functionality built in. I have never written a macro before
so any help would be appreciated.

Tomcat,
Rod's suggestion will certainly do what you requested but I offer a
caution. It would be nice to know the reason you want to delete tasks
with a 1 day Duration. I can think of a few scenarios where 1 day tasks
are significant and relevant to a project plan. Deleting them outright
may not be the best approach.

John
Project MVP