We help IT Professionals succeed at work.
Get Started

Visio Pro Org Chart, VBA,  Update Page from External Data

nbyinfrastructure
on
1,344 Views
Last Modified: 2012-05-08
Hi

I have an external data source that I need to use to update a Visio page. I can do what I need manually, but I would like to write the VBA code to automate the process.

In the external data window at the bottom on the Visio page, I have the followiing column headings. (Name, Department, Position, Costcenter.....ect)

I would like to create some code, where I select all rows where the department is the same (the department=x) and then drop those rows onto blank page with the same department name. The blank page has apready been created.

If it helps, we are using custom Visio shapes, with custom shape data. The shape data does match the external data's columns headings.

Im pretty much lost with how to even start this.

Many  thanks
Comment
Watch Question
Visio Consultant, Trainer, Author, and Developer
CERTIFIED EXPERT
Most Valuable Expert 2011
Commented:
This problem has been solved!
Unlock 1 Answer and 3 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE