How to set BuiltInName to bnPrintTitles in Version 5?

[Claude]

I fail to migrate this code:

Code: Select all

    with xlw2.InternalNames.Add do
    begin
      BuiltInName := bnPrintTitles;
      Definition := 'Sheet4!$A$3:$IV$3';
    end;

I don't know what it does. What did this do in Version 4? How can bnPrintTitles be used in Version 5?

Claude

[larsa]

Hello

Please study the NamedCells sample.

[Claude]

Please study the NamedCells sample.

But I don't know what BuiltInName does. Is there a documentation of what it does in version 4?

[KenWhite]

What you're asking is now done with the PrintSettings.

Code: Select all

var
  Col1, Col2, Row1, Row2: Integer;
begin
  AreaStrToColRow('$A$1:$IV$10', Col1, Col2, Row1, Row2);
  Sheet.PrintSettings.PrintTitles(Col1, Col2, Row1, Row2);
end;