HeaderFooter Page numbers?

[maseline_98]

I was trying to get the page numbers to print, but there seems to problem:

Code: Select all

XLS[SHEET].PrintSettings.HeaderFooter.OddHeader := '&[Page] of &[Pages]';

The result: 'Page] of Pages]'. The strange thing is that if I open the header in excel and click on it, then it displays the page numbers.

I have also tried:

Code: Select all

XLS[SHEET].PrintSettings.HeaderFooter.OddHeader := '\&\[Page] of \&\[Pages]';

[maseline_98]

Nevermind....found the answer in the XLSSheetData5 unit:

For anybody else looking it is:

Code: Select all

XLS[SHEET].PrintSettings.HeaderFooter.OddHeader := '&P of &N';