Re: ParentShape! Help please. (Visio 2007)

Thanks for trying to help John,

You quickly sumerised what it took a few hours for me to learn earlier
today. I'll try and summerise what I am trying to achieve in case anyone has
any sugestions.

We maintain diagrams of the racks in our server rooms, these diagrams are
looked at and updated during projects to show physical layouts or planned
physical layouts. Many of the shapes(Servers/routers etc) contain shape data
for the heat and power consumption etc (and all can have it). We also have an
excel spread*** with the same equipment and the same data the only thing
extra is the spread*** totals this data by rack and by data centre.

If we move a system or do what ifs we need to amend two documents. I hoped
to remove/automate the spread *** based on the diagrams. I.E. put a system
in a rack it could pick up the rack number from the parent. that way I could
run a simple report getting all the data I need.

any ideas?

Thanks in advance
Bob

"John Goldsmith" wrote:

Hello Bob,

The example uses two shapes that it calls (for want of better terms) Parent
and Child. You could actually name your shapes as such but more likely is
that they'll have real ID values

In this case you're entering a formula into the Child shape, whose really ID
might be something like ***.2, so that it tracks the position of the
Parent shape (possibly ***.1). Right click on your first shape that you
want to track and select Format / Special... Make a note of its ID
property, which is at the top. The example calls this shape the parent
shape, So if your ID is 1 say, then your shape reference that you place in
the child shape PinX cell should be "***.1!PinX".

A further point is that the example formula references a two User cells.
These needs to be in place before you add the PinX/Y formulae otherwise
you'll get an error as you're trying to reference a cell that isn't there.

Best regards

John


John Goldsmith
www.visualSignals.co.uk

"Lucky Bob" <LuckyBob@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3E48BF50-E9EB-4F68-B37A-BC8DC30DC4BE@xxxxxxxxxxxxxxxx
The SETATREF Function
(http://msdn2.microsoft.com/en-us/library/ms425563.aspx)

Uses ParentShape!PinX in it's second example. but I just get error in
formula if I try and use it as in the example or on its own.

when I search for ParentShape! it seems like everyone wants this but that
it
doesn't exist!

Does it? if so any idea why it won't work



.