>>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?
>
>try
>
>
>...
>If NOT oSheet.AutoFilterMode
> oExcel.Selection.AutoFilter
>EndIf
>
That did it. Thanks!
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people