>How can I do the following things from VFP via Excel?
>
>1) Freeze the top row of a spreadsheet
>2) Turn on auto-filter
>
>I already have a reference to the excel object (loExcel) and can refer to the active worksheet (loExcel.ActiveWorksheet).
>
>More generally, where can one find that kind of information so you don't need to ask the wonderfully helpful folks of the UT?
>
>Grateful as always,
>
>Alex

o.ActiveWindow.FreezePanes=.f.
o.ActiveWindow.splitrow=1
o.ActiveWindow.FreezePanes=.t.

o.ActiveSheet.usedrange.AutoFilter    && set for range or selection and turn it on
o.Activesheet.AutoFilterMode=.f.  && turn it off

Best Wishes