>I am trying to apply Page Breaks to an excel sheet object. I have identified the cells to apply the breaks. The syntax I get from the Macro goes like;
>
> ActiveWindow.SelectedSheets.HPageBreaks.Add Before:=ActiveCell
>
>I How do I apply this using VFP Syntax assuming the break is to be at cell Loxls.Cells(10,1) ?.
Named parameters are not supported in VFP, but usually Excel has an alternative syntax, which places the parameters (without the names) between parentheses.
So, assuming that loXls is a spreadsheet, I guess that would translate to something similar to:
loSheet.HPageBreaks.Add(loXls.Cells(10,1))
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)