Print Page - Layer Membership export to excel

Title: Layer Membership export to excel
Post by: gemon on March 11, 2009, 12:47:15 PM

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

Title: Re: Layer Membership export to excel
Post by: aledlund on March 11, 2009, 05:49:17 PM

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

Title: Re: Layer Membership export to excel
Post by: Lars-Erik on March 11, 2009, 06:18:56 PM

When I had to link my Visio to Excel I found this (http://www.design-drawing.com/visio/custprop2.htm) 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

Title: Re: Layer Membership export to excel
Post by: gemon on March 16, 2009, 06:02:04 PM

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

Gemon

Visio Guy

Visio Discussions => ShapeSheet & Smart Shapes => Topic started by: gemon on March 11, 2009, 12:47:15 PM