multiple criterias for FilterEdit method, VBA?

[Lucas Sain]

Hi,

I have been strugling on how to add multiple criteria to the FilterEdit
method. I have used this:

FilterEdit Name:="Filter 1", TaskFilter:=True, Create:=True, _
OverwriteExisting:=True, FieldName:="Resource Names", test:="equals", _
Value:=mystring, ShowInMenu:=False, ShowSummaryTasks:=True

FilterEdit Name:="Filter 1", TaskFilter:=True, Create:=False, _
OverwriteExisting:=False, FieldName:="Flag8", test:="equals", _
Value:="No", Operation:="And", ShowInMenu:=False,
ShowSummaryTasks:=True

I'm not sure how to add the second criteria...

Thanks Ahead

 

[Rod Gill]

With all VBA problems like this, record a macro of you creating a filter
with multiple criteria. Then you can edit the recorded code if needed.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[Lucas Sain]

Thanks!!!

That did the trick

With all VBA problems like this, record a macro of you creating a filter
with multiple criteria. Then you can edit the recorded code if needed.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com