Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

How to find/adapt an appropriate set of Document properties for files in Visio 2013?

Posted on 2014-10-07
2
109 Views
Last Modified: 2014-10-07
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?
Thanks, Kelvin
0
Comment
Question by:Kelvin4
2 Comments
 
LVL 26

Accepted Solution

by:
ProfessorJimJam earned 500 total points
ID: 40366716
0
 

Author Closing Comment

by:Kelvin4
ID: 40367544
Thanks, I left a note on the Question re an alternative approach.
Kelvin
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

861 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question