Connecting shapes from data
DataRecordset has a
Reports To column that is used by Organization Chart Wizard to create a hierarchy by connecting the shapes together. The data that connects two shapes together does not need to be in the same
DataRecordset, especially if there are many-to-many relationships.
A lot of the VBA code in this chapter make increasing use of arrays. However, the VBA
IsEmpty() functions do not really report an empty array. Therefore, the following function,
IsEmptyArray(), will return
False by forcing an error if necessary:
Also, much of the code herein needs to get the index of ...