Hello All,
I am trying to automate multi-page visio document. I am familiar with the Business Organization Chart Wizard, but it is very time consuming given I have 10 reporting line managers and my org chart is constantly changing.
Is it possible using VBA based on Excel data to create a Visi Oorg Chart and create a new page in the org chart when a new manager shows up. For example - with the data below I want two pages in Visio for Mike Huss and Allen Chu
Employee Report to Business Unit
Joe Smith Mike Huss Accounting
Angela Jo Mike Huss Accounting
Don Rodgers Allen Chu Operations
Don Roberts Allen Chu Operations
Would appreciate any help.
Thanks
I am trying to automate multi-page visio document. I am familiar with the Business Organization Chart Wizard, but it is very time consuming given I have 10 reporting line managers and my org chart is constantly changing.
Is it possible using VBA based on Excel data to create a Visi Oorg Chart and create a new page in the org chart when a new manager shows up. For example - with the data below I want two pages in Visio for Mike Huss and Allen Chu
Employee Report to Business Unit
Joe Smith Mike Huss Accounting
Angela Jo Mike Huss Accounting
Don Rodgers Allen Chu Operations
Don Roberts Allen Chu Operations
Would appreciate any help.
Thanks