Why are there so few multi-page functions in Visio?

R

Rose

I think it's about to drive me to distraction that some of the standard Visio (2003 Professional) functions work for just one page at a time

With the help of some good souls such as Al Edlund and David Parker, I (not a programmer!!) have managed to write some VBA that executes the "Database Refresh" addon against all (or multiple, as selected) pages in one go

Now I need to update my MS Access DB for all pages at once.....the "Export to Database" function has just the right functionality EXCEPT it only does one page at a time. And I can't find anything anywhere in the Visio online help or in the MS Knowledge Base or in MSDN that gives me even a hint on how I could use the standard functionality in a macro that loops through all my pages (35 now, and still growing.........

This is an appeal to the Visio Developers - - PLEASE can you cater for people who have have Visio docs with more than one page!!!!

Ros
 
J

John Marshall, MVP

Multi page functions are handled by looping through the pages in the page
collection.

"ActivePage" is the current page and "ActiveDocument.Pages" is the
collection of pages in the current document.


Dim PagObj As Visio.Page

For Each PagObj In ActiveDocument.Pages

Next

There is more information about using Visio with VBA at
http://www.mvps.org/visio/VBA.htm


John... Visio MVP

Need stencils or ideas? http://www.mvps.org/visio/3rdparty.htm
Need VBA examples? http://www.mvps.org/visio/VBA.htm
Common Visio Questions http://www.mvps.org/visio/common_questions.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top