Referring to this article:http://visguy.com/vgforum/index.php?topic=6314.0 (http://visguy.com/vgforum/index.php?topic=6314.0)
It's an awesome macro, with a bit of tweeking I can get it to produce exactly what I want.
Only problem is it always fails to run with an "out of bounds" error in the excel portion of the code. If I delete the last two pages of wiring diagrams it will run though. I know a little about visio programming, but nothing about excel programming. I only need it to run on one page anyway so haven't tried to fix it.
Thanks wapperdude, this will create a report that will be very helpful to me!