Microsoft Project 2003 - Issue with Macro and Tasks

[lovemusic]

Hello, I am new to this forum.

I am writing a macro to print a report where the tasks printed are only the tasks specified in the macro, like tasks 21-25 and 33-43 for example.

But when I do this, VB only reutrns a generic:

FilterApply Name:="Tas&k Range..."

I have tried evertything to filter by task range in a macro and print and am stumped.

Any suggestions would be appreciated. Thanks, Joe

 

[PDQBach]

The answer is ... somewhat opaque.

First, the filter you are using needs parameters (start and end task number). Those come from the pop up and the popup is displayed whenever you use the filter but don't provide them.

You obviously know enough to get to the VBA code generated when you recorded the macro. And that meant you were *so* close to the answer.

Go back into that code and on a blank line immediately below the line you found in the macro:

filterapply Name:="Task Range..."

start typing:

filterapply and then press the spacebar.

Intellisense prompts you to enter the necessary parameters. In your case, "value1:=21,value2:=25" (no quotes of course).

 

[lovemusic]

Thanks, however,when I do as instructed, I am still promted to enter the Task ID.

This is my code per your instructions.

FilterApply Name:="Task Range..."
FilterApply value1:=21, value2:=25

Thanks for your help. Joe

 

[PDQBach]

All on one line.


FilterApply Name:="Task Range...", Value1:=21, Value2:=25