Create Flow Chart using Excel VBA

H

hobbsies

I would like to create a flow chart in Excel using Excel VBA. To
manually create a flow chart you would start by selecting Insert ->
Diagram -> Organization Chart, but I would like this to be automated.
However, when I turn on the macro recorder, I am no longer able to add
a new flow chart or edit an existing flow chart.
From looking around online, it looks like Excel is using a program
called Visio to make flow charts. However, Visio is not in my list of
possible VBA references. I found an abundance of help topics on how
to write code in Visio that can access Excel, but is there a way to
write Excel VBA that can create/edit a Visio flow chart in Excel?

Thanks in advance for any suggestions you might have!
 

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