Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Including document property values in Excel headers
I am using Excel 2003 and trying to set up a template that has the header and
footer already configured, and include data found in the document properties (e.g., Title, Subject, Creator) and hopefully custom properties like 'Client' and 'Version' and 'Version Date'. Can someone explain how to define the headers and footers to incorporate such document property elements ? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Including document property values in Excel headers
Just to be clear, I am looking for a solution that doesn't require macros to
be written to set up the header/footer with this information. Looking for a simple solution where the document properties can be accessed like in MS Word and incorporated into the Excel header/footer. Thanks. "d_m_y" wrote: I am using Excel 2003 and trying to set up a template that has the header and footer already configured, and include data found in the document properties (e.g., Title, Subject, Creator) and hopefully custom properties like 'Client' and 'Version' and 'Version Date'. Can someone explain how to define the headers and footers to incorporate such document property elements ? Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Including document property values in Excel headers
You will need macros to return the information you want.
Sample code................ Sub Stuff_In_Footer() With ActiveSheet.PageSetup .LeftFooter = _ ThisWorkbook.BuiltinDocumentProperties("Title") & " " & _ ThisWorkbook.BuiltinDocumentProperties("Subject") & " " & _ ThisWorkbook.BuiltinDocumentProperties("Author") & " " & _ Format(ThisWorkbook.BuiltinDocumentProperties("Cre ation Date"), _ "yyyy-mmm-dd hh:mm:ss") .LeftHeader = ThisWorkbook.CustomDocumentProperties("Client") End With End Sub Gord Dibben MS Excel MVP On Thu, 25 Sep 2008 15:58:01 -0700, d_m_y wrote: Just to be clear, I am looking for a solution that doesn't require macros to be written to set up the header/footer with this information. Looking for a simple solution where the document properties can be accessed like in MS Word and incorporated into the Excel header/footer. Thanks. "d_m_y" wrote: I am using Excel 2003 and trying to set up a template that has the header and footer already configured, and include data found in the document properties (e.g., Title, Subject, Creator) and hopefully custom properties like 'Client' and 'Version' and 'Version Date'. Can someone explain how to define the headers and footers to incorporate such document property elements ? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Chart Series Values Property Size Limitation | Charts and Charting in Excel | |||
SeriesCollection Values Property Oddity | Charts and Charting in Excel | |||
Connect document properties to headers and footers | Excel Discussion (Misc queries) | |||
List of property names and values for a given object. | Excel Worksheet Functions | |||
Can you reference cell values in Headers and Footers in Excel 200. | Excel Discussion (Misc queries) |