I have the following code (Run from MS Access 2003 -- Early Binding):
<Snipped unneeded code>
Dim objXL as New Excel.Application
with objXL
<Snipped unneeded code>
If fEmail Then
'Delete Status Column
.Range("A7").Select
.Selection.AutoFilter
.Columns("N:N").Select
.Selection.Delete Shift:=xlToLeft
.Range("A7:M7").Select
.Selection.AutoFilter
'Filter on Open Items:
.Range("A7:M7").Select
.Selection.AutoFilter Field:=11, Criteria1:="No"
'Filter for specified PosterLoc:
If Not IsMissing(strPosterLoc) Then
.Range("A7:M7").Select
.Selection.AutoFilter Field:=8, Criteria1:=strPosterLoc
End If
End If
When I go into the excel application, the dropdown filters are blue and have the correct filter turned on. However only the first row is filtered.
Any ideas?
Bookmarks