>Hi
>Maybe i'm just being a bit dumb on this one. I want to leave the user facing a spreadsheet that has freezpanes and autofilter already set. All the rest of the formatting is done elsewhere in the program, and I just have these two elements to sort out.
>
>Alan
>
>
>*- Finish
>oSheet.PageSetup.PrintArea = "$A$1:$S$8800"
>
>oSheet.Range("A8").Select
>oSheet.FreezePanes = "True"
>
>oSheet.Range("A8:S8800").Select
>oSheet.Selection.AutoFilter

So, why do not you follow the Excel Macro?
There are no statements like oSheet.FreezePanes = "True". And FreezePanes you can apply to the Excel ActiveWindow, not sheet object.

And, sure, if there were already freezepanes, and splitted rows or columns that you wish to change, then you should first unfreeze panes, set split rows/coplumns as needed, and set freezepanes to .t. again.

If you have problems translating the VBA code from MAcro to VFP, then show here what you got in VBA code.