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!!

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

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