Visio VBA help

[trishc]

I am trying to export shape data from my Visio flowchart. I am hoping to get the shape displayed text, shape number, associated hyperlink description, associated hyperlink address, and the associated comment. I would also be nice to know, if possible, what swimlane function the shape sites in. I also don't want OneD shape, and I only want the flowchart shapes. I figured out the OneD, but not flowchart only shapes. The Shape Report on in Visio doesn't allow me to select the fields I want for output. I created the code below, but can only get the shape text. I split them out so I could try each one. After a few hours, I have given up. Any suggestions?

Sub ShapeInfoToFile()
      Dim strPath As String
      strPath = "C:\Users\collinsp\Documents\SSC\Chief Technical Officer\Enterprise Architecture\E2E Architecture Working Group\Process"
      Dim MyFile As String
      MyFile = strPath & "\E2EArchWG Visio Report"
      Open MyFile For Output As #2
      Dim vPage As Visio.Page
      Dim vShape As Visio.Shape
      Dim vShapeLinkDes As String
      Dim vShapeLink As String
      Dim Entry As String
      Set vPage = Visio.ActivePage
      ' Loop through shapes creating a string containing them all, writing to file
      For Each Shape In vPage.Shapes
          Set vShape = Shape
          If Not vShape.OneD Then
              Set vShapeLinkDes = vShape.Hyperlink.Description.Value
              Set vShapeLink = vShape.Hyperlink.Address.Value
              Entry = vShape.Text
              Entry = Entry + "," + vShape.Type
              Entry = Entry + "," + vShapeLinkDes
              Entry = Entry + "," + vShapeLink
              Entry = Entry + "," + vShape.Comments
              Write #2, Entry
          End If
     Next Shape
End Sub

[trishc]

okay, figured out the Hyperlinks (because there could be multiple, I had to do a loop), now the comments, which are the most important

Sub ShapeInfoToFile()
      Dim strPath As String
      strPath = "C:\Users\collinsp\Documents\SSC\Chief Technical Officer\Enterprise Architecture\E2E Architecture Working Group\Process"
      Dim MyFile As String
      MyFile = strPath & "\E2EArchWG Visio Report"
      Open MyFile For Output As #2
      Dim vPage As Visio.Page
      Dim vShape As Visio.Shape
      Dim vShapeLinkDes As String
      Dim vShapeLink As Hyperlink
      Dim Entry As String
      Set vPage = Visio.ActivePage
      ' Loop through shapes creating a string containing them all, writing to file
      For Each Shape In vPage.Shapes
          Set vShape = Shape
          If Not vShape.OneD Then
            Set vShapeLinkDes = vShape.Hyperlink.Description.Value
            Set vShapeLink = vShape.Hyperlinks
            Entry = vShape.Text
            Entry = Entry + "," + vShape.Type
            Entry = Entry + "," + vShapeLinkDes
            ' Loop through the shape hyperlinks
            For Each vShapeLink In vShape.Hyperlinks
                Entry = Entry + "," + vShape.Hyperlinks.Item(0).Description + "," + vShape.Hyperlinks.Item(0).Address
                Next vShapeLink
               Entry = Entry + "," + vShape.Comments
               Write #2, Entry
           End If
     Next Shape
End Sub

[Bob Phillips]

Not sure I will be able to help, I am pretty raw with the Visio OM, but if you could post an example workbook and an idea what the output would look like, I will have a shot at it.

[trishc]

Not sure I will be able to help, I am pretty raw with the Visio OM, but if you could post an example workbook and an idea what the output would look like, I will have a shot at it.

I have given up trying to extract the comment associated with the shape. I realize now the comment is considered another shape. Instead, I manually entered the same number I numbered the shape with at the start of the comment, so I can match them later in Excel. For example, if I numbered the shape 5.2.1, then the comment will start with "5.2.1".
So I now generate two files, one with only "process" shape data, and one with the comment data.


The only issue I have is that it only works on the active page, despite adding in the For each page in the active document code. Maybe I am missing something. If I can get that to work, I am good to go. Because I do the loop twice, the first time for the shapes, and the second time for the comments, I need to make sure I start back at the first page for each loop through the document. Any suggestions?

Sub ShapeInfoToFile()
      Dim strPath As String
      strPath = ActiveDocument.Path
      Dim MyFile As String
      MyFile = strPath & "E2EArchWG Visio Shape Report"
      MyFile2 = strPath & "E2EArchWG Visio Comment Report"
      Open MyFile For Output As #2
      Open MyFile2 For Output As #3
      Dim vDoc As Visio.Document
      Dim vShape As Visio.Shape
      Dim vComments As Visio.Comments
      Dim vShapeLink As Hyperlink
      Dim vPage As Visio.Page
      Dim Entry As String
      Dim sText As String
      Set vDoc = Visio.ActiveDocument
      ' Loop through shapes creating a string containing them all, writing to file
      For Each Page In vDoc.Pages
          Set vPage = Visio.ActivePage
          For Each Shape In vPage.Shapes
              Set vShape = Shape
              If Not vShape.Master Is Nothing Then
                  ' Select only Process shapes
                  If vShape.Master.NameU = "Process" Then
                      ' Get Page Name
                     Entry = vPage.Name
                     ' Get shape displayed text
                     Entry = Entry + "," + vShape.Text
                     ' Loop through the shape Hyperlinks
                     For Each vShapeLink In vShape.Hyperlinks
                         Entry = Entry + "," + vShape.Hyperlinks.Item(0).Description + "," + vShape.Hyperlinks.Item(0).Address
                     Next vShapeLink
                     ' Append shape comment
                     Entry = Entry + "," + vShape.Comments
                     Write #2, Entry
                End If
             End If
         Next
    Next
    ' Loop through comments creating a string containing them all
    For Each Page In vDoc.Pages
        Set vPage = Visio.ActivePage
        For Each vComment In vPage.Comments
             sText = vPage.Name + "," + vComment.Text
             Write #3, sText
        Next
    Next
End Sub