Loop to see only tasks in a filter?
Hi Steve,
There are two ways about this.
What first comes to mind, is forget about the filter, in the Tasks
collection evaluate the filter condition, and only handle Excel if the
filter condition is met.
The second way is as follows:
View Apply ........ (the view that is to be filtered)
FilterApply .......
Select all
for each anytask in activeselection.tasks
Next anytask
HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
Project Management Consultancy
Prom+ade BVBA
32-495-300 620
Quote:
> I am trying to create some Project 2000 VBA code that will
> loop through tasks in a filter and place particular values
> into Excel.
> I have the Excel piece working (for the most part - it
> doesn't seem to like the template part of the .Add, but I
> can get a blank worksheet up and manipulate it).
> What I can't do is apply a filter in project and then only
> refer to the tasks in that filter. I can only see to
> figure out how to identify the activeproject.tasks
> collection. Is there no way to specify the collection of
> tasks that result from a filter?
> Thanks for any help. Steve
