Using shapes' connection points and connectors to generate Excel f

[BillD]

I am creating an electrical connectivity drawing for a rack assembly and,
since there are a few hundred cables, I would like to auto-generate a
cablelist from the drawing. To do this I need to be able to label the
connection points (ports) of the shapes (devices) on both ends of a connector
(cable). Several of the devices have many ports. Then, using VBA, generate
an Excel file which will consist of a list of the individual cables together
with the labels of the devices and the ports at both ends of the cable.
Questions:

1) How many connection points does a shape have and how do I label them?
2) Can you point me in the right direction for creating the VBA code to
generate the cablelist? (I know Excel VBA quite well but have no experience
with Visio VBA.)

Thanks in advance.

 

[Chris Roth [Visio MVP]]

Hi BillD,


You can add as many connection points to a shape as you need.

Connection points can be named to some extent using the ShapeSheet.

There's a thread about this in the Visio Guy newsgroups, including some
VBA code for working with the connections:

http://visguy.com/vgforum/index.php?topic=163.0

--
Hope this helps,

Chris Roth
Visio MVP


Visio Guy: Smart Graphics for Visual People

Articles: http://www.visguy.com
Shapes: http://www.visguy.com/shapes
Dev: http://www.visguy.com/category/development/
Forum: http://www.viguy.com/vgforum