VBA frustration - StatusDate & FilterEdit   

Project 2003, SP3, Windows XP Professional.
I have been trying to edit filters and statusdate in VBA, but the
following does not work, can any one please give me the correct
syntax, words, code

FilterEdit Name:="filtername", _
                           TaskFilter:=True, _
                           FieldName:="text1", _
                           NewFieldName:="", _
                           test:="equals", _
                           Value:=Me.cboPlan.Value, _
                           Operation:=strOperation, _
                           ShowSummaryTasks:=False

i have tried the following, application.activeproject.FilterEdit,
MSProject.ActiveProject.FilterEdit,

Similar for StatusDate, which i want to to update through VBa using a
form

    'Application.ActiveProject , StatusDate = TxtDate didnt work
  'ActiveProject.StatusDate = TxtDate didnt work
'Application.StatusDate = txtdate

Can any one advise me what else to try.....

regards

date: Wed, 2 Jul 2008 10:58:05 -0700 (PDT)   author:   pipmonck

RE: VBA frustration - StatusDate & FilterEdit   

The best way to figure out filteredit syntax is to turn on the macro recorder 
and create the new filter. Then modify any of the parameters.
I always do that first both because I'm lazy and my memory is not perfect.

ActiveProject.StatusDate = txtDate should work if txtDate is really a date.
What is the value of txtDate? What data type is it?

for example this code works:

Sub setStatusDate()
Dim txtDate As Date
txtDate = Now()
ActiveProject.statusdate = txtDate
End Sub

"pipmonck" wrote:

> Project 2003, SP3, Windows XP Professional.
> I have been trying to edit filters and statusdate in VBA, but the
> following does not work, can any one please give me the correct
> syntax, words, code
> 
> FilterEdit Name:="filtername", _
>                            TaskFilter:=True, _
>                            FieldName:="text1", _
>                            NewFieldName:="", _
>                            test:="equals", _
>                            Value:=Me.cboPlan.Value, _
>                            Operation:=strOperation, _
>                            ShowSummaryTasks:=False
> 
> i have tried the following, application.activeproject.FilterEdit,
> MSProject.ActiveProject.FilterEdit,
> 
> Similar for StatusDate, which i want to to update through VBa using a
> form
> 
>     'Application.ActiveProject , StatusDate = TxtDate didnt work
>   'ActiveProject.StatusDate = TxtDate didnt work
> 'Application.StatusDate = txtdate
> 
> Can any one advise me what else to try.....
> 
> regards
>

date: Wed, 2 Jul 2008 11:27:16 -0700   author:   Jack Dahlgren