ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Putting the document number custom property in workbook (https://www.excelbanter.com/excel-programming/364100-putting-document-number-custom-property-workbook.html)

DRK

Putting the document number custom property in workbook
 
I am using the custom property "document number" to keep a version control
number for a workbook distributed to many people. What I want to do is print
that value in the footer of the printout so I know which version they ran
their case.

The custom property type is text.
--
DRK

DRK

Putting the document number custom property in workbook
 
I figured it out after posting the original message.
Range("VersionNumber") = ActiveWorkbook.CustomDocumentProperties("Document
number")
--
DRK


"DRK" wrote:

I am using the custom property "document number" to keep a version control
number for a workbook distributed to many people. What I want to do is print
that value in the footer of the printout so I know which version they ran
their case.

The custom property type is text.
--
DRK



All times are GMT +1. The time now is 06:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com