Layer Membership export to excel

[gemon]

Hi,
is there any way I can export the layer membership property of all the shapes in my diagram to an excel so that I can have a sort of map of which shapes belong to which layers?

I'd like something like:

Shape Name	Layer1	Layer2	Layer3	Layer4
MyShape1	X	X
MyShape2	X		X	X
MyShape3	X
MyShape4				X

any chance I can do it? Do I have to custom code something?
Thanks a lot
Gemon

[aledlund]

You're correct. It will require some custom code.
al

[Lars-Erik]

When I had to link my Visio to Excel I found this internet page very helpfull. It passes custom properties to Excel. You could change this to do what you want it to with a basic VBA knowledge.

- Lars

[gemon]

thanks both for the replies 
I will take a look at the link you provided and see if I can reuse something... 

Gemon