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 <TomOgi...@discussions.microsoft.com>
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!