I got the code down to use the autofilter but am having problems with the date format for the filter.
There must be a one liner to give me a date in the MM/DD/YYYY format like Filterdate=today()-365
This is what I got so far
[vba]
Dim curyear As Date
curyear = today() - 365
Format(curyear, "mm/dd/yyyy")
Workbooks.Open Filename:="C:\BDR\33activity.xls"
Application.Goto Reference:="data"
Selection.AutoFilter
Selection.AutoFilter Field:=5, Criteria1:=curyear, Operator:=xlAnd
[/vba]
Just having one of those days again!