| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom File Properties
Can I add Custom File Properties into Header and Footer information. eg
&[Tab] but I need to add client info, etc that comes from Templates I have set -- Wise and Stupid at the same time!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Custom File Properties
Yes, if you use code.
Look at CustomDocumentProperties in VBA's help. You could extract the property by using its name and then plop it into the header/footer (also using code). Ade Hodgetts wrote: Can I add Custom File Properties into Header and Footer information. eg &[Tab] but I need to add client info, etc that comes from Templates I have set -- Wise and Stupid at the same time!! -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Custom File Properties
Sub Print_Custom_Props()
With ActiveSheet j = ThisWorkbook.CustomDocumentProperties("Client").Va lue n = ThisWorkbook.CustomDocumentProperties("Editor").Va lue ActiveSheet.PageSetup.RightHeader = "Client Name " & j ActiveSheet.PageSetup.LeftHeader = "Editor " & n End With ActiveSheet.PrintPreview End Sub Gord Dibben MS Excel MVP On Wed, 2 Apr 2008 11:19:01 -0700, Ade Hodgetts wrote: Can I add Custom File Properties into Header and Footer information. eg &[Tab] but I need to add client info, etc that comes from Templates I have set |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Showing Custom file properties in Header | Excel Discussion (Misc queries) | |||
| i am having problem displaying the custom properties | Excel Discussion (Misc queries) | |||
| How do I display custom file properties in a cell | Excel Discussion (Misc queries) | |||
| Custom File Properties | Excel Discussion (Misc queries) | |||
| Can I display the file properties of a workbook in a custom headi. | Excel Worksheet Functions | |||
Linear Mode
