Using VBA to convert Excel flowcharts to Visio

[Rachel Garrett]

At my job, they have a lot of process diagrams and flowcharts that are
in Excel spreadsheets. There are rectangular boxes, text inside them,
and line connectors. Since I've been asked to convert them to Visio,
I'm wondering about ways to do it automatically.

For each rectangle shape in Excel sheet
Create a Process shape in Visio
Excel AutoShape rectangle dimensions = Visio process shape
dimensions
Excel AutoShape rectangle placement = Visio process shape
placement
Excel AutoShape rectangle text = Visio process shape text
End

For each line connector in Excel sheet
Create a line connector in Visio
Excel line connector start = Visio line connector start
Excel line connector end = Visio line connector end
Excel line connector type = Visio line connector type
Excel line connector text = Visio line connector text
End

I haven't done much VBA programming, and none in Visio. So I'd like to
get a feel for whether this smells doable, or perhaps whether somene
has already done it.

Thanks!
Rachel

 

[AlEdlund]

One of the MVPs has a great intro tutorial on just this problem. Check it
out
http://www.visguy.com/2006/09/13/create-visio-flowcharts-programmatically/
al