Re: How to update multiple stencils when linked with Excel databas

Tech-Archive recommends: Speed Up your PC by fixing your registry

Give me a few days and I will crank one out. It is not a lot of code, it is
just a problem finding the time.

So basically you want something to change the value of a custom property of
a certain name to a new value in all the stencils of a directory.

John... Visio MVP

Need stencils or ideas? http://visio.mvps.org/3rdparty.htm
Need VBA examples? http://visio.mvps.org/VBA.htm
Visio Wishlist http://visio.mvps.org/wish_list.htm
"JessicaRose" <JessicaRose@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:11AE0781-4E0A-491A-A0B9-CF7A2C4FDEC6@xxxxxxxxxxxxxxxx
So what would be the best resource for writing codes for my situation?

"John Marshall, MVP" wrote:


So I guess one key feature is that you do not want already created
drawings
to update to the new prices.

So it is possible to search a stencil and change the value of a custom
property. You can write code that loops through all stencils in a
directory,
find all shapes using a specific custom property and then update that
value
from a data source line Excel or Access.

John... Visio MVP

Need stencils or ideas? http://visio.mvps.org/3rdparty.htm
Need VBA examples? http://visio.mvps.org/VBA.htm
Visio Wishlist http://visio.mvps.org/wish_list.htm
"JessicaRose" <JessicaRose@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6AA961F4-498F-4147-8F5F-51197D0A2209@xxxxxxxxxxxxxxxx
I mean stencils. What we have is a collection of various symbols with
about
11 custom properties field attached. Several people use these symbols
to
design cable systems. Sometimes, something such as price may change,
and
we
wanted to be able to go into a spread***, change let's say, 100
symbol's
pricing, then have it automatically update within the stencil file, so
future
drawings can pull the symbol with updated information. It would be so
much
quicker to update within a database, rather than going into each master
and
editing the cusom properties individually

"John Marshall, MVP" wrote:

Do you mean drawings rather than stencils? A stencil is a collection
of
shapes. When a drawing is created the shapes are copied from a stencil
to
a
local stencil that is part of the drawing. It is possible to update
the
masters in the local stencil and have all the appearances of those
shapes
on
the drawings automatically updated.

John... Visio MVP

Need stencils or ideas? http://visio.mvps.org/3rdparty.htm
Need VBA examples? http://visio.mvps.org/VBA.htm
Visio Wishlist http://visio.mvps.org/wish_list.htm
"JessicaRose" <JessicaRose@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1112E42C-E15F-4F6D-9C2B-F3F197D8D1C3@xxxxxxxxxxxxxxxx
I am working on a project that uses multiple stencil files. I am
able
to
export to an excel database, and refresh each symbol by dragging to
the
drawing, but am wondering how I could update multiple symbols at one
time
in
the actual stencil file from the excel database? The ONLY updates I
can
find
update one at a time and I am needing a quicker way to update my
symbols'
custom properties all at once, rather than editing each individual
custom
property. I am using visio 2003 standard.
Is this possible with Visio and excel?








.

Quantcast