Text only | Text with Images

Visio Guy

Visio Discussions => Programming & Code => Topic started by: Michael M on February 17, 2011, 12:31:49 AM

Title: Autopopulate OrgChart
Post by: Michael M on February 17, 2011, 12:31:49 AM
Hi All
I've googled everywhere for a solution, but I'm beginning to wonder if I can actually do it...
I have created an OrgChart in Excel 2003, by using Insert / Diagram / Org chart.
It only has about 6 boxes at the moment but will expand significantly.
What I am trying to do is have a range of cells with employee details AND the shape No on the worksheet.
When the employee details change it automatically updates the text in the shapes using a macro...is this even possible.
I note that the shape No's are different to normal shapes inasmuch as they are numbered like _s1025, _s1026, etc.

Name   Position           Shape Name
Bob   Manager              _s1025
Ted   Assistant Manager  _s1026
Bill   Salesman              _s1027
Alice   Admin               _s1028
ANY assistance would be appreciated

Regards
Michael M
Title: Re: Autopopulate OrgChart
Post by: aledlund on February 19, 2011, 12:41:36 AM
It's possible
http://visguy.com/vgforum/index.php?topic=2298.0
al
Text only | Text with Images
Browser ID: smf (is_webkit)
Templates: 1: Printpage (default).
Sub templates: 4: init, print_above, main, print_below.
Language files: 1: index+Modifications.english (default).
Style sheets: 0: .
Hooks called: 47 (show)
Files included: 25 - 925KB. (show)
Memory used: 748KB.
Tokens: post-login.
Cache hits: 8: 0.00157s for 22,291 bytes (show)
Cache misses: 3: (show)
Queries used: 12.

[Show Queries]