I am using Visio2010's cross-functional diagrams for our process flow. Currently, the process has hundreds of blocks most with notes attached through a hyperlink manually entered into each block. There are two locations for notes one for editable pages and one for pdfs. Previously, I went through each block to change path and extension for each block with note pages. I want to automate the process since the process is going through major revisions.
I have a working copy in one location and a protected public version in another. I am a firm believer in having separate working and final versions.
What I want
If the Visio file is opened in one location it will open the pdf version of the notes, if opened from other locations it opens the docx version. The pdfs are in a publicly accessible location while the docx files are restricted access.
What I have done
The file name is based on text entered into the block. Block text always starts with a predefined code. The code is the file name.
In a User-defined cell, I extract the code using SHAPETEXT(TheText) function, then use string functions to extract just the code.
In User.NotePath, I put the formula IF(Directory()="\\IP address\Forms and Policies\Process Flow", "\\IP address\Forms and Policies\Process Flow\Notes\","\\IP address\Working Dir\Process Flow\Notes\"). It ALWAYS evaluates as true no matter what directory I open the file from, yet DIRECTORY reports the correct source path.
Another cell contains contains another IF statement to select the extension. In yet another cell I assemble the entire path and filename. (I know this can be done in one cell but I want to see the output of each step, at least for now.) The cell evaluating the extension selection also ALWAYS evaluates as true. The formula I am using is IF(User.NotePath="\\IP address\Forms and Policies\Process Flow\Notes\",".docx",".pdf")
I have replaced spaces in the path with %20, added quotes, removed quotes, put the DIRECTORY() statement in its own cell and referenced that, and a few other things all to no avail.
I have other IF statements that are evaluating correctly. These other statements turn on and off other shapes in the grouped shape and change its color based on data in the grouped shape's properties.
I am working with the shape's mastershape shapesheet.
What am I missing? Microsoft's shapesheet help is about useless.
Is it that it cannot evaluate the \s?
Is there a solution I can use?
Thank you in advance for any assistance.