>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
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.