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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - Problem with Closing Print Preview 0
vba in excel 2007 5
Ole Server Error related to Office 2007 installation 2
NETWORKDAY + Excel 2007 + Excel 2003 1
Problems with Automaint Excel 5
Excel 2007 Move or Copy worksheet 2
OLE gridlines printing in Word 2007 2
Automation Ole Excel conditional formatting with PowerBuilder 9 0

Back
Top