Does this work?

Sub Stuff_In_Footer()
With ActiveSheet.PageSetup
.LeftFooter = _
ThisWorkbook.BuiltinDocumentProperties("Revision number")
End With
End Sub


Gord Dibben MS Excel MVP

On Fri, 3 Apr 2009 06:18:02 -0700, Kevin Hancock
wrote:

I'm using the Document Managemen Server and would like to have the version
number of a file displayed in the footer along with the filename. I have the
filename appearing fine, but can't figure out the variable for "Version".

I tried &[Version] , but no luck.