Off-Page Connector Shape Names

[Seption]

I'm working on applying the off-page connector usage to some custom shapes
that I have, and I'm wondering if there's a property of the shape object that
stores the name of the shape that it's linked to? I need to be able to
reference each of the linked shapes from the other one in a VBA module.

Thanks for your help!

 

[David Parker]

If you are using the OPC addin, look at the User cells that get created ...
you will find the page and shape UniqueIDs there

 

[Seption]

Thank you for your reply, it helped a lot! I do have one more question
though: Is there any way to turn the hex code returned into a typical
"sheet.XX" type of reference?

For example, the User.OPCDShapeID cell contains
"{AE7473DE-FA22-40A4-AA1A-7F3EE7DBA3A8}". Is it necessary to convert this
string, or will this work as the shapeID in the shapes object in my VBA
module?

 

[John Goldsmith \(Visio MVP\)]

Hello Seption,

These 'GUIDs' are unique shape references used in code, so yes they'll work
perfectly in your vba. From memory the OPC addin has three main user cells
that it adds GUIDs to - one for the actual shape, one for page, and one for
the target shape.

Have a look over here for reference:
http://msdn.microsoft.com/en-us/library/aa201782(office.10).aspx#350

Best regards

John


John Goldsmith (Visio MVP)
www.visualSignals.typepad.co.uk
www.visualSignals.co.uk

 

[Seption]

Thank you John, that solved my problem!

Hello Seption,

These 'GUIDs' are unique shape references used in code, so yes they'll work
perfectly in your vba. From memory the OPC addin has three main user cells
that it adds GUIDs to - one for the actual shape, one for page, and one for
the target shape.

Have a look over here for reference:
http://msdn.microsoft.com/en-us/library/aa201782(office.10).aspx#350

Best regards

John


John Goldsmith (Visio MVP)
www.visualSignals.typepad.co.uk
www.visualSignals.co.uk