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
Hi, Kelly!
You don't need write macro, this process managed by build-in OrgChart add-on