I'm trying to add a horizontal page break in an Excel sheet using OLE automation with Delphi.
I've found (using recording an Excel macro) that the HPageBreaks.Add method should be used. But I can't get this working.
Does anyone ever used this method to insert a horizontal page break in an Excel sheet.
Thanks for any help,