| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Ole Automation and Excel 2007 footer
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Ole Automation and Excel 2007 footer
With Sheets("SheetName").PageSetup
.CenterFooter = "test" End With works in Excel 2007 "Press YES if this post helps" "Greborio Robert" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Ole Automation and Excel 2007 footer
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. "Abdul" wrote: With Sheets("SheetName").PageSetup .CenterFooter = "test" End With works in Excel 2007 "Press YES if this post helps" "Greborio Robert" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I add a hyperlink to the footer in Excel 2007 | Excel Discussion (Misc queries) | |||
| Excel 2007: Add year to footer | Excel Discussion (Misc queries) | |||
| Can you put a standard footer on Excel 2007 spreadsheets? | Excel Discussion (Misc queries) | |||
| How to add a footer to an Excel 2007 worksheet | Excel Discussion (Misc queries) | |||
| Excel 2007 :Standard Footer | Excel Worksheet Functions | |||
Linear Mode
