• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1471
  • Last Modified:

Organization chart by Visio

I am looking to build dynamic organization chart by MS Visio connected  with databases.

The title, name, picture and as needed information must lable and stick where the position.

I need to do it with VB.net.


The database contain Two fileds:
Parent
Child

If parent is 0 so it will be separate level as (or can ve new company with it's levels)

Child will take new sequence or selected number (can be the employee number)
Paretn will be the top level manager of the employee (employee_manager_number)

We can level its as needed like we can put like the name of the section as level and under it the name of the staff to be show.

I have done somthing like that in Treeview and it's work fine but with I didn't done it with Visio library in VB.net 2010.

I need also to printed.
chart.xlsx
0
abdallah1973
Asked:
abdallah1973
  • 2
1 Solution
 
Patrick MatthewsCommented:
This is a VBA routine which, if run from Excel, will automate Visio and use the Org Chart Wizard to populate the org chart with data from an Excel file.

You should be able to take this approach and port it to VB.Net, and to connect to a database if necessary.
0
 
abdallah1973Author Commented:
What is recommanded links or  site should I read to do it?
0
 
abdallah1973Author Commented:
Most of these example without read emplyee personal picture.

I am try to find somthing with showing image also
0
 
Scott HelmersVisio Consultant, Trainer, Author, and DeveloperCommented:
Two suggestions for sample code -- both are VBA but should give you good ideas:
This article provides code to automate creation of a Visio org chart. It happens to build one based on the Windows directory structure starting in a folder selected by the user. However, it does so by writing directory data to Excel and then running the Visio org chart wizard to produce the org chart.
Because the Visio org chart wizard does not have an option to insert images into org chart shapes automatically, this blog post contains VBA code to add images to Visio org chart shapes.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now