I am trying to figure out how to use the .Autofilter to filter a column in and excel spreadsheet from Access. It always wants an = Object at the end of the codeset.
I tried
XlApp = Excel.Application
Field 8 = Column H
Plat is the filter in Column H
True is I want to see the filter arrow.
Set WkBkA = Workbooks.Open("C:\Temp\BalanceSheet_New.xlsx")
Set varSheetA = WkBkA.Worksheets(1).Range(strRangeToCheck)
xlApp.AutoFilter(8, "Plat", , True) = varSheetA