Organization chart by Visio

Posted on 2012-08-11
Last Modified: 2012-08-12
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

The database contain Two fileds:

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 2010.

I need also to printed.
Question by:abdallah1973
    LVL 92

    Expert Comment

    by:Patrick Matthews
    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.

    Author Comment

    What is recommanded links or  site should I read to do it?

    Author Comment

    Most of these example without read emplyee personal picture.

    I am try to find somthing with showing image also
    LVL 30

    Accepted Solution

    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.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now