multi-page flowchart from Excel

[mbrinkma]

I am experimenting with using the macro in Visio 2003 to create flowcharts
using data from an Excel spreadsheet.

I need to create a fairly simple, but large (multi-page) flowchart. Is
there a way, using a single spreadsheet file, to create a flowchart that
spans multiple pages in Visio?

There is an "off-page reference" stencil that seems to generate a second
page but I cannot figure out how to add boxes to that second (and subsequent)
page.

 

[Bill Morein [MSFT]]

It sounds like you are trying to add shapes to that second page
programmatically. If so, you just do so by making sure that you are
referencing the page when you drop the shapes. A simple way to do this in
VBA is "ActiveDocument.Pages(2).Drop(...)"

--
Bill Morein
Office Graphics - Visio
Microsoft Corporation
http://blogs.msdn.com/wmorein

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[mbrinkma]

Is there a way to generate multi-page flowcharts using the capabilities
already in Visio and Excel, without needing to develop VBA software? What I
would like to do is to create multi-page process flowcharts by enterring the
source data into Excel (or something) in text form and then having Visio
create the document automatically. This would make both initial flowchart
generation, and especially updates, much more efficient.

 

[Bill Morein [MSFT]]

We don't support generating flowcharts automatically from Excel data by
default in Visio 2003.

If you install the Visio SDK
(http://www.microsoft.com/downloads/...BD-B0BB-46E7-936A-B8539898D44D&displaylang=en),
there is a sample application (the Flowchart one) that does what you
describe, so you might be able to use that.

--
Bill Morein
Office Graphics - Visio
Microsoft Corporation
http://blogs.msdn.com/wmorein

This posting is provided "AS IS" with no warranties, and confers no rights.