longjonsilvr
10-25-2012, 08:18 AM
I have 3 sets of filters I want to apply. I have no problem with the filter code, its the "Or" code between filters im struggling with.
Currently I have:
SetAutoFilter FieldName:="Start", FilterType:=pjAutoFilterThisWeek
SetAutoFilter FieldName:="% Complete", FilterType:=pjAutoFilterCustom, Test1:="does not equal", Criteria1:="100%"
Then I need "OR"
SetAutoFilter FieldName:="Start", FilterType:=pjAutoFilterThisWeek
SetAutoFilter FieldName:="% Complete", FilterType:=pjAutoFilterCustom, Test1:="does not equal", Criteria1:="100%"
Another "OR"
SetAutoFilter FieldName:="Status", FilterType:=pjAutoFilterLate
SetAutoFilter FieldName:="% Complete", FilterType:=pjAutoFilterCustom, Test1:="does not equal", Criteria1:="On Schedule"
Does anyone have any ideas how to replicate is filter in code.
Currently I have:
SetAutoFilter FieldName:="Start", FilterType:=pjAutoFilterThisWeek
SetAutoFilter FieldName:="% Complete", FilterType:=pjAutoFilterCustom, Test1:="does not equal", Criteria1:="100%"
Then I need "OR"
SetAutoFilter FieldName:="Start", FilterType:=pjAutoFilterThisWeek
SetAutoFilter FieldName:="% Complete", FilterType:=pjAutoFilterCustom, Test1:="does not equal", Criteria1:="100%"
Another "OR"
SetAutoFilter FieldName:="Status", FilterType:=pjAutoFilterLate
SetAutoFilter FieldName:="% Complete", FilterType:=pjAutoFilterCustom, Test1:="does not equal", Criteria1:="On Schedule"
Does anyone have any ideas how to replicate is filter in code.