I am trying to use Excel automation to turn on AutoFilter:
oExcel = CREATEOBJECT("Excel.Application")
oWorkbook = oExcel.Workbooks.Open(sFileName)
oSheet = oExcel.Workbooks(1).ActiveSheet
oSheet.Cells.Select()
oSheet.AutoFilter = TRUE
I get the error "Member not found" on the AutoFilter line. The AutoFilter property shows up in IntelliSense.
Anyone know what I'm doing wrong?
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
