Thanks!!

>This work for me:
>
>ObjExcel.Range("A1").AutoFilter(13, "jphilipp")
>
>
>
>>I would like to use VFP7 to create an Excel SpreadSheet. The data comes from a couple of tables, one original data, the other corrected. I’ve combined them into a cursor then placing them onto the clipboard and pasting it into the spreadsheet. They want the information of the edited records to be in a different color. Using Excel’s autofilter ( a VERY cool feature ) I can filter the changed records and set the color. I am unable to figure how to do that thru VFP. My code:
>>
>>

_VFP.DATATOCLIP(,,3)
>>oXL = CREATEOBJECT("Excel.Application")
>>oXL.workbooks.ADD( )
>>oXL.ActiveSheet.paste
>>oXL.RANGE("A1").SELECT
>>oXL.SELECTION.AutoFilter

>>
>>This gets everything set up but now I need to pick the column and the filter.
>>
>>The macro produces:
>>

Range("A1").Select
>>Selection.AutoFilter
>>Selection.AutoFilter Field:=13, Criteria1:="jphilipp"

>>
>>Any idea how I convert it to fox code?
>>
>>BTW, the spreadsheet will end up with 14,000 records and it takes too long to loop through and add the records one by one (unless I’m doing something wrong.)
>>
>>Thanks!