Can I access Organisation Chart with VBA?

[Lionel H]

Microsoft Organisation Chart is a tool which seems to be wholly embedded in
Powerpoint. I would like to be able to use VBA to extract names, titles and
comments from an org chart into an Excel spreadsheet. I can find nothing in
the object browser about organisation charts or their Objects, methods,
properties etc. Any attempt to generate explanatory macros by setting "record
new macro" and then editing the org chart leaves no trace of how it was done.
Is it actually possible to extract this information, and if so, how please?
I am on W2k/O2K.

 

[Lionel H]

However, consider creating a copy of the org chart object (possibly on a new
slide), ungrouping the copy and working with the resulting PPT shapes.

Many thanks for overcoming my inability to think laterally.
As you suggested, I copied a relevant chart to a blank slide, selected the
object and clicked on Ungroup. I got a message saying it couldn't ungroup an
embedded object, but it would convert it into a drawing object for me if I
didn't mind losing embedded data and linked information. I said, "Go ahead"
and hey presto, an "ungrouped organisation chart". None of the information I
was after seems to have been lost.
Once again thanks.