Visio Guy

Solution-specific Visio Discussions => Org Charting => Topic started by: kellyscott on April 15, 2019, 09:37:37 PM

Title: Automate Organization Chart in Visio
Post by: kellyscott on April 15, 2019, 09:37:37 PM
Hello!

I am able to create an Organization Chart using Visio and data that I imported from Excel without any problem.  However, I would like to automate the whole process using Macro or VBA.  I recorded the macro but the macro doesn't seem to record the process of importing data from Excel and draw the organization chart from the imported data.  Therefore, I am thinking that I need to write VBA code to automate this process, but I don't have a lot of VBA experience.

I am wondering if anyone has done this automation process and can give some advices? 

Thank you,
Kelly
Title: Re: Automate Organization Chart in Visio
Post by: Surrogate on April 16, 2019, 12:27:40 AM
Hi, Kelly!

You don't need write macro, this process managed by build-in OrgChart add-on