My Visio files (vsdm with VBA functions), go through a life cycle of stages: draft -> test -> passed test.
I want excel to maintain worksheet lists of these 100s of different docs, with files names, paths, creation dates etc.
I thought it would be nice to use document properties for my life cycle stages, as they can be set via vba and read without opening individual files. But:
1. I dont see custom document properties for Visio 2013; do/can they in fact exist?
2. I dont want my users changing these life cycle properties by directly typing into the File>AdvancedProperties interface. I will provide a separate interface to modify doc properties via vba. Is that possible in visio?
3. If custom properties are not available in Visio, I could write my life cycle properties as a parsible string (ugh!) in DocumentProperties.Comments, but I'd like those strings to be hidden from user view in BACKSTAGE, but still readable/writable by via vba procedures.
Can you advise me please: Is this approach sensible, or what other method should I use to meet my requirement?