Transfering Data between Shapes with Connections

[Paul Jolley]

Is it possible to take data from one shape (Values on the shape sheet) and
transfer them to another shape via a connector line?

I want to use the values of a connected shape in a formular of the shape I
am working on, just by connecting the shape with the connector tool.

Say shape A had a custom property of x, can I reference that property in a
shape sheet cell in shape B just fom the fact shape A & B are connected by a
connection line? So the cell formular would be something of the form, "value
= value x of connected cell)

Is this possible?

 

[AlEdlund]

not without custom code.
sorry,
al

 

[Paul Jolley]

When you say, "not without custom code" do you mean putting some VB code into
a cell in the shape sheet to link it to the connected cell? If so, where
would I find the VB code to reference such a link?

Regards,

Paul

 

[AlEdlund]

Visio stopped allowing 'code' in the shapesheet quite awhile ago (security
reasons). No, I was referring to writing real code (vba/vb/c?/etc) to
capture the connection event, read both of the shapes shapesheets that are
impacted by the connection, and then do the updates. Examples of the code
for capturing events and updating shapesheets is available in the visio sdk.
al

 

[vojo]

I played with this and posted on visio.guy website. Got it working with no
code but it is extremely extremely extremely kludging. I realy dont think
its really for prime time. maybe it spawns new think that could make it
prime time

In essence, you have a broker shape and source and sink shape that register
with the broker shape thru cells in the page. source /sink usesknown cells
to post messages, broker shape pulls from source and push to sink (and other
cells for vice versa).

Its really not pretty!!!! but does work.

good luck

 

[David J Parker]

This earlier blog of mine (Setting Visio Shape Cell Values By Connections )
may be of interest:
http://bvisual.spaces.live.com/Blog/cns!3350D61BC93733A9!347.entry

 

[David J Parker]

Actually, you have prompted me to write another blog closer to your
requirements:
http://bvisual.spaces.live.com/blog/cns!3350D61BC93733A9!1278.entry
Tell me if it helps.