'How to get a custom document property using a formula
In an Excel formula, is it possible to get a custom document property without an external add-in or help from VBA code?
Solution 1:[1]
No, you need to call a macro for that. However, you can link a custom property to the cell content, see Using “Link to content” to Define custom file properties in Excel for more information. In that case you could refer to the cell which delivers a custom property value for your formula calculations.
Solution 2:[2]
Yes. Just display your property in a cell like {{property_name}} and use the cell coordinates in the formula.
For example: =VERKETTEN(""; B3; "test"; B3)
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Eugene Astafiev |
| Solution 2 | jafischer |