| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Putting Excel Charts into a Word document that's getting too big | Charts and Charting in Excel | |||
| Putting NAMEs or REFERENCES into Custom Number Formats | Excel Discussion (Misc queries) | |||
| Can you link a custom property to an Excel custom header text? | Setting up and Configuration of Excel | |||
| Putting a logo into a Custom Header | Excel Discussion (Misc queries) | |||
| Workbook property telling number of sheets | Excel Programming | |||
Hybrid Mode
