View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Minion Minion is offline
external usenet poster
 
Posts: 5
Default Display document version number in Header or Footer?

Please excuse my limited knowledge, but I'm not sure exactly what to do with
the subroutine below. Perhaps you could provide intstructions of where to
paste this code or a link to instructions on it.

"Gord Dibben" wrote:

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.