I wish to print some File custom properties in the Footer of a page - for example, the version number of a excel document.

How do I go about doing that? It's very easy in Word, but not so in Excel.

Roger has brought this to us :
I wish to print some File custom properties in the Footer of a page - for
example, the version number of a excel document.

How do I go about doing that? It's very easy in Word, but not so in Excel.

In XL2007 the *Header and Footer* menuitem is on the *Insert* tab. In
earlier versions this is on the *View* dropdown menu.

In all versions this can be accessed via the *Print* dialog *OR* within
*Print Preview*.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

On Thursday, November 1, 2012 6:53:23 AM UTC+13, GS wrote:
Roger has brought this to us :

I wish to print some File custom properties in the Footer of a page - for

example, the version number of a excel document.



How do I go about doing that? It's very easy in Word, but not so in Excel.



In XL2007 the *Header and Footer* menuitem is on the *Insert* tab. In

earlier versions this is on the *View* dropdown menu.



In all versions this can be accessed via the *Print* dialog *OR* within

*Print Preview*.



--

Garry



Free usenet access at http://www.eternal-september.org

Classic VB Users Regroup!

comp.lang.basic.visual.misc

microsoft.public.vb.general.discussion

I may not have made myself very clear.
The file properties I wish to include in either a header or foot are found by selecting File\Properties\Custom - then various fields can be added by a user along with variables - Text\numerical etc.
The Header\Footer regions of a file can be accessed as explained by Gary above.
What is not clear is how to link the File custom properties into the Header\Footer area - the options available in "Custom Header\Footer" are limited.

I suspect a VBA solution is required.

The Workbook.BuiltinCustomProperties obect is exposed to VBA, and so
can be accessed for read/write. The Header/Footer can also be accessed
in VBA via Worksheet.PageSetup. Thus, you can read the desired props
and then write them to the Header/Footer as desired.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion