Putting the document number custom property in workbook

G

Guest

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.
 
G

Guest

I figured it out after posting the original message.
Range("VersionNumber") = ActiveWorkbook.CustomDocumentProperties("Document
number")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display Custom Document Property 1
Custom Document Properties in Word documents and Excel workbooks 13
Custom Document Properties 3
Workbook custom document properties 1
Adding Custom property 9
dont see custom document properties... 1
Printing Excel File Custom Properties in the Footer 3
function with collection of custom objects as results 0

Top