Author Topic: Automate Organization Chart in Visio  (Read 268 times)

0 Members and 1 Guest are viewing this topic.

kellyscott

  • Newbie
  • *
  • Posts: 1
Automate Organization Chart in Visio
« 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

Surrogate

  • Hero Member
  • *****
  • Posts: 898
    • ShapeSheet™ Knowledge Base
Re: Automate Organization Chart in Visio
« Reply #1 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