Outputing Org Chart Relationship Data to Excel
Posted on 2010-11-11
I've got a series of Org Charts for our company. These Org Charts define Executive/Managers and reports to structures. I'm trying to create a VBA macro that will output the name of the employee, and the reports to executive to an excel spreadsheet. Since the org charts are seperate visio files, I'm going to use FSO to cycle through and open each file, and I know the excel object well enough to create the excel output. My weak point is not knowing the visio object well enough to get the relationship data. I've discovered how to cycle through each shape in a page, but I can't figure out how to determine what Master shape that the current shape is linked to? If I can ID the master/linked shape, I should be able to extrat the custom text that I need from the shape. Thanks in advance.