I tried that already. I get "Unable to set the AutoFilterMode property of the Worksheet class.."
FYI, the help here
http://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.worksheet.autofiltermode(VS.80).aspx says you can set it to False, but not True.
Probably because setting AutoFilter to True turns on the arrows automatically.
>Try
>
>oSheet.AutoFilterMode = .F.
>
>
>>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