Ole Automation and Excel 2007 footer

  • Thread starter Thread starter Greborio Robert
  • Start date Start date
G

Greborio Robert

Till Excel 2003 the following row worked correctly:
Sheet.PageSetup.CenterFooter:='Print from...'; (Delphi 2009)
But now create an Exception irreparable Error!!
I've see in the VBA help the procedure is changed in Excel 2007. I've tried
various system but ever same error.

Can you help me?
Tks in advance.
Robert
 
With Sheets("SheetName").PageSetup

.CenterFooter = "test"

End With

works in Excel 2007

"Press YES if this post helps"
 
Tks Abdul this answer get me exact idea for write the procedure for Delphi
2009:

Sheet.Item['SheetName'].PageSetup.CenterFooter:='Print from...';

The MSOffice help is not very clear about this change. A three of all object
will be more interesting.
 
Back
Top