Project 2003 macro filters

[Finius Eetch]

I have a couple of questions that i'm sure have simple answers.

1) FilterEdit. Is it possible to generate a multi-line filter? One that
looks something like this.

FilterEdit Name:="WheelWorkFilter", TaskFilter:=True, Create:=True, _
OverwriteExisting:=True, FieldName:="Resource Names", test:="Contains
exactly", _
Value:=mystring, FieldName:="Start", test:="is greater than or equal
to", Value:=StartDate, _
FieldName:="Finish", test:="is less than or equal to",
Value:=FinishDate, _
ShowInMenu:=False, ShowSummaryTasks:=False

2) How can I get calendar information returned to a variable to use in my
calculations? Currently i'm doing this.

StartDate = InputBox("Enter Start Date")
FinishDate = InputBox("Enter Finish Date")

Which makes me type in dates into the box. What I want to happen is I want
the calendar to pop up so i can pick Start and and Finish and then apply them
in my filter.

When I run the macro I want the user to be forced to choose a date range
(Start and Finish). I then want to create a multi-line Filter that takes in
some of those variables and runs through some loops to generate and print
report fragments. If the Filter can be made the why I listed it AND if I can
get the calendar dates the way I listed them, I believe i'm well on my way.

The end goal is to have a 1 button solution that will print weekly tasks
lists for each active resource between two dates.

Thanks.

 

[Rod Gill]

Hi,

Record a macro of you creating a multi-part filter and you have your start.

You can get different calendar controls to use, but they cause installation
headaches. If you want a period of a week, after the start date has been
entered, add 7 days to it and use it as a default value in the next
inputbox. That way most of the time people only need to enter one date.