Using VBA with Visio

Hello

I wondered if anyone has any experience of using VBA with Visio?

Basically, I can get the org chart in Visio, and they are set out based on who reports to who, which is the standard model.

What I need to do, is set up code so that i have a page per department, per location, with the most senior person at the top.

I assume I'll have to do some manual adjustments as a Line Manager might manage more than one department, and I want them showing at the top of each page of each department they manage.

But if anyone has attempted anything like this before, I'd be really grateful to hear from you. I've just done the VBA intermediate, so fairly new to it, but I know it can be done!

Thanks

Gem.