Re: Adding colour to shapes for 56 pg org chart at once & not page

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thank you very much Al.

At present I utilize an excel document with some 700 employees in it and was
hoping to only be able to perhaps update differences rather than drawing the
whole org chart from the wizard function from start to finish again.

Will check the SDK package and a trial version of 2007 for your other
recommendations.

Cheers MRFoster



"AlEdlund" wrote:

First part
yes you can write a vba macro that will check all shapes for a specific
custom property and then change the color of the shape. There are examples
in the visio sdk for reading shape custom properties and updating shape
cells using vb code.
Second part
Technically you can link visio drawings to external data several ways.
However. Currently the recommendation is to use v2007 with datalinking.
Second. The org chart wizard redraws everything (by design) when you call
it. So any changes you made to the drawing since the last time you called it
are lost.....
al

"MRFoster" <MRFoster@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BC0969D1-9B23-4934-9A67-AF2105FAE578@xxxxxxxxxxxxxxxx
Hello all,
after running an org chart I would use the color add on to add
colour to all shapes using the staff level. I have to do this page by
page.
Do you think it would be possible to write a VBA script that would look at
all shapes in the entire document and depending on a certain custom
porperty
field add colour that way?

I am hoping to create some sort of VBA script, that would say, "Look at
all
shapes in entire document, if APS6 fill shape colour green, if APS5 fill
shape colour blue and so on and so on.

Part2.
I have read many web pages reagrding updating your org chart via a data
base
so that I would not have to rebuild from scratch all the itme. Can some
one
recomend a text book or a link that would allow me to fully undersatnd
this
claim and put it into practice?

Thank you all in advnace.

Mark
Regards,
Mark

.

Relevant Pages

  • Re: Adding colour to shapes for 56 pg org chart at once & not page by
    ... yes you can write a vba macro that will check all shapes for a specific custom property and then change the color of the shape. ... The org chart wizard redraws everything when you call it. ... shape colour blue and so on and so on. ...
    (microsoft.public.visio.general)
  • Re: Cannt connectting shapes....
    ... I wonder if you've created the drawing from the Org Chart stencil rather than being based on the template? ... John Goldsmith (Visio MVP) ...
    (microsoft.public.visio.general)
  • RE: Shapes resize when pasted
    ... "WapperDude" wrote: ... pages have identical setup, scales are the same, then, all should be good. ... But, since you used the template shapes to create your original drawing, you ... without using the org chart template) into a newly created file based on the ...
    (microsoft.public.visio)
  • Re: How do I show org charts in normal mode
    ... The Org chart functionality introduced in that version requires a Drawing ... A Drawing Canvas is a SHAPE, and is therefore only visible in the ... reply in the newsgroup and not by e-mail :-) ...
    (microsoft.public.word.docmanagement)
  • Re: MakeOrganizational chart stable unchanged when adding objects
    ... Have you used the Org Chart ... drawing the stuff on the slide. ... > boxes, graphics and autoshapes to the design. ...
    (microsoft.public.powerpoint)