If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Transfering Data between Shapes with Connections
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? |
#2
|
|||
|
|||
Transfering Data between Shapes with Connections
not without custom code.
sorry, al "Paul Jolley" wrote in message ... 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? |
#3
|
|||
|
|||
Transfering Data between Shapes with Connections
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" wrote: not without custom code. sorry, al "Paul Jolley" wrote in message ... 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? |
#4
|
|||
|
|||
Transfering Data between Shapes with Connections
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 "Paul Jolley" wrote in message ... 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" wrote: not without custom code. sorry, al "Paul Jolley" wrote in message ... 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? |
#5
|
|||
|
|||
Transfering Data between Shapes with Connections
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 "Paul Jolley" wrote: 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? |
#6
|
|||
|
|||
Transfering Data between Shapes with Connections
This earlier blog of mine (Setting Visio Shape Cell Values By Connections )
may be of interest: http://bvisual.spaces.live.com/Blog/...33A9!347.entry "Paul Jolley" wrote in message ... 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? |
#7
|
|||
|
|||
Transfering Data between Shapes with Connections
Actually, you have prompted me to write another blog closer to your
requirements: http://bvisual.spaces.live.com/blog/...3A9!1278.entry Tell me if it helps. "David J Parker" wrote in message ... This earlier blog of mine (Setting Visio Shape Cell Values By Connections ) may be of interest: http://bvisual.spaces.live.com/Blog/...33A9!347.entry "Paul Jolley" wrote in message ... 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? |
Thread Tools | |
Display Modes | |
|
|