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!

this article might give some hints.

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

--
Regards,
Tom Ogilvy


"hobbsies" wrote:

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!

On May 4, 3:28 pm, Tom Ogilvy
wrote:
this article might give some hints.

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

--
Regards,
Tom Ogilvy



"hobbsies" wrote:
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!- Hide quoted text -

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