Delete Filters through VBA

J

JJ

I've written some code which creates filters. However, over the
development period the names of the filters have changed which causes
some filters to become outdated, but they remain in the file. All of
the filters begin with the same 5 characters. For sake of argument,
let's say they all start with "ABCDE". I want to be able to find all
filters which begin with those characters and delete them in order to
clean out all the old filters before building (or re-building) the new
ones.

I've tried to find ways to get to a Filter "collection" in MS Project
so that I can get to the name of each filter. There doesn't seem to be
one a collection object for Filters.

Is there a way do accomplish what I want to do?

Thanks!
JJ
 
J

JJ

Thanks Jan! I knew I could count on you for an answer! I always forget
that there are Task Filters and Resource Filters. Thanks again!
 
J

Jan De Messemaeker

You're welcome, JJ

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf
Thanks Jan! I knew I could count on you for an answer! I always forget
that there are Task Filters and Resource Filters. Thanks again!
 

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

Similar Threads

On Double Click - Filter Transactions to New WorkSheet 0
How do I filter data by more than one column in excel 0
Import filtered data from Project to Excel using VBA not filters/ 8
Filter not working as expected 3
Filtering a form with a combo box using left function 4
Filter on report no longer works as it used to 0
Form permanently filtered? 4
Open form on filter 3

Top