How to turn on the AutoFilter in Excel?

[SRAutomater]

I am having trouble enabling AutoFilter in Excel. The VB macro looks like:

Sheets("Sheet1").Select

Range("A1").Select

Selection.AutoFilter

I am trying:

$oExcel.activesheet.Range("A1").select

$oExcel.selection.autofilter

I get a COM error though 'Unable to get the AutoFilter property of the Range class" (number 80020009)

Any help is appreciated.

Thanks

[DaRam]

Can you verify that Cell A1 is NOT empty?

You cannot autofilter an empty (list) range.

Try this:

$oExcel.ActiveSheet.Range("A1").Autofilter

I am having trouble enabling AutoFilter in Excel. The VB macro looks like:

Sheets("Sheet1").Select

Range("A1").Select

Selection.AutoFilter

I am trying:

$oExcel.activesheet.Range("A1").select

$oExcel.selection.autofilter

I get a COM error though 'Unable to get the AutoFilter property of the Range class" (number 80020009)

Any help is appreciated.

Thanks

Edited October 8, 2008 by DaRam

[erik7426]

I am having trouble enabling AutoFilter in Excel. The VB macro looks like:

Sheets("Sheet1").Select

Range("A1").Select

Selection.AutoFilter

I am trying:

$oExcel.activesheet.Range("A1").select

$oExcel.selection.autofilter

I get a COM error though 'Unable to get the AutoFilter property of the Range class" (number 80020009)

Any help is appreciated.

Thanks

This works for me...

$myExcel = ObjCreate("Excel.Application")
With $myExcel
        .Visible = True
        .WorkBooks.Open("C:\temp.xls")
EndWith

$myExcel.Cells(1,1).Select
$myExcel.Selection.Autofilter

[SRAutomater]

Both of these solutions worked.

Thank you Erik and DaRam!