>I am having trouble with Excel automation, I am trying to sort on column 7 within the spreadsheet from within vfp. The latest code I am using is
>
>.range(.cells(1,1),.cells(65536,256)).sort(.range(.cells(1,7),.cells(65536,7)),xlDescending,xlGuess,1,"False",xlToptoBottom)
>
>I got this code from looking at the macro within Excel, but no matter what I try I am either getting an error or it doesn't sort. If any one can help with this, it would be appreciated.
>
>Darren Donald
Have you seen my introductory article on Excel automation?
In this case, you need the constants xlDescending, etc. - available from the download section (search for "constants").
What WITH statement are you using with the above code?
What error message do you get?
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)