VBA to open excel in visio and create org chart

[NewtoVisiotoo]

Hi,

Can anyone pls help me with a VBA code.
My requirement is to import an excel file data into visio 2007 and create an organisation chart from it.


Thanks in advance.

[aledlund]

you might check david parker's site.

http://blog.bvisual.net/2009/02/24/creating-an-org-chart-without-the-org-chart-wizard/

al

[NewtoVisiotoo]

Thanks for the reply.

I have created an excel file with dummy details..... like:

1. Name of the resource
2. Designation
3. Team Name
4. Name to link to Stencil (this should be used as reference to pick the stencil)
5. Line Manager

I have created multiple stencils based on City, Employee type (this name is the same as point 4.)
The stencil names are:

1. India_Perms (orange color black outline)
2. India_Contractor (orange color dotted outline)
3. India_Graduate (orange color dash outline)
4. Vacant (white color black outline)
5. UK_Perms (blue color black outline)
6. UK_Contractor (blue color dotted outline)
7. UK_Graduate (blue color dash outline)

Need a macro that will create the org chart depending on point 4 as reference using the stencil corresponding to it and aligning based on line manager.

Please help

[NewtoVisiotoo]

Can it be achieved via Data Graphics and Macro? Can someone help...

[contact_ankit86]

I do the same thing daily.. I create lots and lots of charts from excel file, Access file. Can you tell me the structure of the excel file or if possible send it to me. I can help

[AmiVisio]

Sample VBA code somewhere?

[Yacine]

Probably better to open a new thread or to specify your question.

[aledlund]

Visio has a sample orgchart excel file as part of the  install. It's in the visio content directory and is called orgdata.xls

al