I have previously written about using off-page references and labelled page grids in Visio, see A Page Grid with Labels and Page Grids and Off Page References, however a reader pointed out that the label on the Off-Page Reference shape is duplicated on both ends. This is not always ideal, however it is all I could do using just ShapeSheet formulas alone. So, in this article, I show how a VBA macro can enhance the reciprocal labels on the twin Off-Page Reference shapes, and they automatically update if either end is moved between grids. This is especially useful in electrical wiring diagrams, but the principal can be adapted for other purposes.
[Read more…] about Bi-directional Labels on Off-Page Grid ReferencesHyperlinks
Updating Visio SharePoint Hyperlinks in Code
Const idProp As String = “Prop._VisDM_ID”
Dim pag As Visio.Page
Dim i As Integer
Dim urlOld As String
Dim id As String
Dim urlNew As String
For Each shp In pag.Shapes
If shp.CellExistsU(“Prop.” & urlCell, Visio.visExistsAnywhere) _
And shp.CellExistsU(idProp, Visio.visExistsAnywhere) Then
urlOld = shp.Cells(“Prop.” & urlCell).ResultStr(“”)
id = shp.Cells(idProp).ResultStr(“”)
urlNew = Left(urlOld, Len(urlOld) – 5 – Len(Format(id, “#”))) & “DispForm.aspx?ID=” & Format(id, “#”)
shp.Cells(“Hyperlink.” & urlCell & “.Address”).FormulaU = “=””” & urlNew & “”””
End If
Next shp
Next pag
Hyperlinks to SharePoint Lists from Visio Shapes
My previous post showed how to link Visio Timelines to a SharePoint Calendar ( http://bvisual.spaces.live.com/blog/cns!3350D61BC93733A9!552.entry ), and I glibbly mentioned how you can create hyperlinks automatically on the shapes from the SharePoint list. Well, that was true, but the example shown goes to a SharePoint page, and it didn’t work. So, I feel I need to demonstrate a fix for it.
[Read more…] about Hyperlinks to SharePoint Lists from Visio Shapes
Importing Hyperlinks into Visio Shapes
Visio shapes can have multiple hyperlinks, but it can be a chore to add them with the Insert / Hyperlinks … command. Fortunately, Visio 2007 Professional has the Data / Link Data to Shapes … command.
If you were to have a data source, such as an Excel spreadsheet, that contains hyperlinks (see the example below)…