Custom File Properties

[Ade Hodgetts]

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

 

[Dave Peterson]

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).

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

 

[Gord Dibben]

Sub Print_Custom_Props()
With ActiveSheet
j = ThisWorkbook.CustomDocumentProperties("Client").Value
n = ThisWorkbook.CustomDocumentProperties("Editor").Value
ActiveSheet.PageSetup.RightHeader = "Client Name " & j
ActiveSheet.PageSetup.LeftHeader = "Editor " & n
End With
ActiveSheet.PrintPreview
End Sub


Gord Dibben MS Excel MVP