Create Flow Chart using Excel VBA

[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!

 

[Guest]

this article might give some hints.

http://support.microsoft.com/default.aspx/kb/317293/en-us

 

[hobbsies]

this article might give some hints.

http://support.microsoft.com/default.aspx/kb/317293/en-us

--
Regards,
Tom Ogilvy






- Show quoted text -

I had tried using PowerPoint because that is were I usually create
flow charts, but I didn't think of using Word. This example works
perfectly, THANKS!