How do address a Connection Point's Type/C property in VBA?

T

tngengineer

I am trying to "walk the connection points" of my drawing. If a connection
point's type is Outward, I transfer data to the connected shape. If the
connection point's type is Inward, I retrieve data from the connected shape.

The trouble is, I cannot figure out how to access the connection point's
Type property programatically.
 
J

JuneTheSecond

visCnnctType might be a index to get direction, for ex.
For Each shp In ActivePage.Shapes
N = shp.RowCount(visSectionConnectionPts)
For I = 0 To N - 1
Set mycell = shp.CellsSRC(visSectionConnectionPts, _
visRowConnectionPts + I, visCnnctType)
Debug.Print mycell.Formula
Next
Next
 
P

Paul Herber

I am trying to "walk the connection points" of my drawing. If a connection
point's type is Outward, I transfer data to the connected shape. If the
connection point's type is Inward, I retrieve data from the connected shape.

The trouble is, I cannot figure out how to access the connection point's
Type property programatically.

You want to use the CellsSRC or CellU methods and the cell name is
visCnnctType.
 
T

tngengineer

Bingo!
Thank you JuneTheSecond

JuneTheSecond said:
visCnnctType might be a index to get direction, for ex.
For Each shp In ActivePage.Shapes
N = shp.RowCount(visSectionConnectionPts)
For I = 0 To N - 1
Set mycell = shp.CellsSRC(visSectionConnectionPts, _
visRowConnectionPts + I, visCnnctType)
Debug.Print mycell.Formula
Next
Next
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top