Page 1 of 1
How to set BuiltInName to bnPrintTitles in Version 5?
Posted: Wed Mar 23, 2016 10:51 am
by 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
Re: How to set BuiltInName to bnPrintTitles in Version 5?
Posted: Mon Apr 04, 2016 7:24 am
by larsa
Hello
Please study the NamedCells sample.
Re: How to set BuiltInName to bnPrintTitles in Version 5?
Posted: Tue Apr 05, 2016 7:59 am
by Claude
larsa wrote:Please study the NamedCells sample.
But I don't know what
BuiltInName does. Is there a documentation of what it does in version 4?
Re: How to set BuiltInName to bnPrintTitles in Version 5?
Posted: Wed May 18, 2016 1:17 pm
by 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;