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.

Re: delete certain tasks macro by Rod

Rod
Fri May 20 17:31:33 CDT 2005

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

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more


"Tomcat" <Tomcat@discussions.microsoft.com> wrote in message
news:467EF4E7-29F1-4203-9315-204D4F5CCEBA@microsoft.com...
> 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.



Re: delete certain tasks macro by John

John
Sat May 21 11:35:05 CDT 2005

In article <467EF4E7-29F1-4203-9315-204D4F5CCEBA@microsoft.com>,
Tomcat <Tomcat@discussions.microsoft.com> wrote:

> 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