>>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
Another question: where do you go to look for such information? Help file? Web site?
Thanks again,
Alex