• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 17. Getting Data from Visio Draw... > Iterating Through Sections and Rows ...

Iterating Through Sections and Rows in Visio ShapeSheets

Just as we have seen in Listing 17.6, using CellsSRC can make locating a particular cell easier if you are not sure exactly where that cell is. Remember that the Shape object also has the SectionExists, RowExists, CellExists, and CellsSRCExists properties to assist you in determining the validity of a particular Cell object.

A Shape object also has the RowCount and RowsCellsCount properties to set limits for iteration. The following sample code fragment iterates through the Geometry1 section of a SmartShape symbol's ShapeSheet and lists each Cell object's formula in the VBS Immediate or Debug window.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint