Add Property Fields to Excel Header/Footer

[Pivot]

I've been asked to create a template for documents created in the company I work for.

I was hoping to prompt the user when he/she uses the template to enter some of the document properties and then to use these in the Header & Footer.

I have seen that I could use a built in Macro that uses the following code.

Function getProperty(propID As Integer)
getProperty = ActiveWorkbook.BuiltinDocumentProperties.Item(propID).Value
End Function

to return one of the preset properties, but this would entail me saving as a Macro Enabled workbook, which is not what is wanted.

I see that I can enter tags into the header and footer such as &[Path] or &[File] that return certain values, but can't seem to find a tag I could use to populate the TITLE or SUBJECT from the document properties.

Any thoughts would be appreciated.

 

[Norie]

There is no way you can do this without using code as far as I know.