News:

Happy New Year!

Main Menu

Automatic Master selection with Excel data

Started by Eddy85, October 31, 2015, 08:03:31 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Eddy85

Hello,

I have a problem to connect my Data automaticly with my Master Shapes.
Two years ago there was a similar topic here but I don´t understand how the VBA code works.

http://visguy.com/vgforum/index.php?topic=4892.msg19335#msg19335

In my case I have different sort of apple and six typ of Boxes. If I drag an drop one data row, Viso should automaticly choose the right
box or rather the right Master Shape.

Is there someone who can solve these Problem? I become desperate of it.

Thanks a lot. Greetings Eddy...


Yacine

I don't think there is a way telling Visio which master to chose when you drag data on the page. There is always only one chosen.
What you can however do, is setup the shape so it adapts its appearance according to the data.

For example
prop.shapeType=2
in geometry section 2, in the field invisible, you'd write =not(prop.shapeType=2)
The other geometry section would have similar formulas, but with 1,3,4,etc.

Instead of geometry sections, you can also work with sub-shapes embedded in the master.
There's a nice article from Chris about hiding shapes (and sub-shapes): http://www.visguy.com/2006/09/05/the-hidden-world-of-visio-shapes/
Yacine

Browser ID: smf (possibly_robot)
Templates: 4: index (default), Display (default), GenericControls (default), GenericControls (default).
Sub templates: 6: init, html_above, body_above, main, body_below, html_below.
Language files: 4: index+Modifications.english (default), Post.english (default), Editor.english (default), Drafts.english (default).
Style sheets: 4: index.css, attachments.css, jquery.sceditor.css, responsive.css.
Hooks called: 158 (show)
Files included: 34 - 1306KB. (show)
Memory used: 1055KB.
Tokens: post-login.
Cache hits: 13: 0.00177s for 26,602 bytes (show)
Cache misses: 3: (show)
Queries used: 16.

[Show Queries]