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?

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@discussions.microsoft.com> wrote in message
news:1112E42C-E15F-4F6D-9C2B-F3F197D8D1C3@microsoft.com...
>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?

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 spreadsheet, 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@discussions.microsoft.com> wrote in message
> news:1112E42C-E15F-4F6D-9C2B-F3F197D8D1C3@microsoft.com...
> >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?
>
>
>

you might want to check this out.
http://msdn.microsoft.com/en-us/libr...ffice.10).aspx
al
"JessicaRose" <JessicaRose@discussions.microsoft.com> wrote in message
news:6AA961F4-498F-4147-8F5F-51197D0A2209@microsoft.com...
>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 spreadsheet, 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@discussions.microsoft.com> wrote in message
>> news:1112E42C-E15F-4F6D-9C2B-F3F197D8D1C3@microsoft.com...
>> >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?
>>
>>
>>

Al, that is a broken link.

John... Visio MVP

"AlEdlund" <edlund@ameritech.net> wrote in message
news:43D6BAC4-BF30-41E9-93E3-999C6566CF1B@microsoft.com...
> you might want to check this out.
> http://msdn.microsoft.com/en-us/libr...ffice.10).aspx
> al
> "JessicaRose" <JessicaRose@discussions.microsoft.com> wrote in message
> news:6AA961F4-498F-4147-8F5F-51197D0A2209@microsoft.com...
>>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 spreadsheet, 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@discussions.microsoft.com> wrote in message
>>> news:1112E42C-E15F-4F6D-9C2B-F3F197D8D1C3@microsoft.com...
>>> >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?
>>>
>>>
>>>
>

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@discussions.microsoft.com> wrote in message
news:6AA961F4-498F-4147-8F5F-51197D0A2209@microsoft.com...
>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 spreadsheet, 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@discussions.microsoft.com> wrote in message
>> news:1112E42C-E15F-4F6D-9C2B-F3F197D8D1C3@microsoft.com...
>> >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?
>>
>>
>>

John,
I just tried it and it works from here ? In any case it's the network demo
from msdn library (office development) that shows how to do the database
lookup for BOM.

Visio 2000 Technical Articles
Custom Visio Solution: Network Configuration Example (Visio, Access, and
Excel Integration)

al


"John Marshall, MVP" <lancucki@stonehenge.ca> wrote in message
news:%23QsAHUCzIHA.2292@TK2MSFTNGP03.phx.gbl...
> Al, that is a broken link.
>
> John... Visio MVP
>
> "AlEdlund" <edlund@ameritech.net> wrote in message
> news:43D6BAC4-BF30-41E9-93E3-999C6566CF1B@microsoft.com...
>> you might want to check this out.
>> http://msdn.microsoft.com/en-us/libr...ffice.10).aspx
>> al
>> "JessicaRose" <JessicaRose@discussions.microsoft.com> wrote in message
>> news:6AA961F4-498F-4147-8F5F-51197D0A2209@microsoft.com...
>>>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 spreadsheet, 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@discussions.microsoft.com> wrote in message
>>>> news:1112E42C-E15F-4F6D-9C2B-F3F197D8D1C3@microsoft.com...
>>>> >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?
>>>>
>>>>
>>>>
>>
>
>

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@discussions.microsoft.com> wrote in message
> news:6AA961F4-498F-4147-8F5F-51197D0A2209@microsoft.com...
> >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 spreadsheet, 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@discussions.microsoft.com> wrote in message
> >> news:1112E42C-E15F-4F6D-9C2B-F3F197D8D1C3@microsoft.com...
> >> >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?
> >>
> >>
> >>
>
>
>

It keeps sending me to
http://msdn.microsoft.com/en-us/library/ms123402.aspx

Is it possible that you have that page cached on your machine?

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
"AlEdlund" <edlund@ameritech.net> wrote in message
news:CCEF06EE-37CD-4DED-AA58-6CF58350FB44@microsoft.com...
> John,
> I just tried it and it works from here ? In any case it's the network demo
> from msdn library (office development) that shows how to do the database
> lookup for BOM.
>
> Visio 2000 Technical Articles
> Custom Visio Solution: Network Configuration Example (Visio, Access, and
> Excel Integration)
>
> al
>
>
> "John Marshall, MVP" <lancucki@stonehenge.ca> wrote in message
> news:%23QsAHUCzIHA.2292@TK2MSFTNGP03.phx.gbl...
>> Al, that is a broken link.
>>
>> John... Visio MVP
>>
>> "AlEdlund" <edlund@ameritech.net> wrote in message
>> news:43D6BAC4-BF30-41E9-93E3-999C6566CF1B@microsoft.com...
>>> you might want to check this out.
>>> http://msdn.microsoft.com/en-us/libr...ffice.10).aspx
>>> al
>>> "JessicaRose" <JessicaRose@discussions.microsoft.com> wrote in message
>>> news:6AA961F4-498F-4147-8F5F-51197D0A2209@microsoft.com...
>>>>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 spreadsheet, 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@discussions.microsoft.com> wrote in message
>>>>> news:1112E42C-E15F-4F6D-9C2B-F3F197D8D1C3@microsoft.com...
>>>>> >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?
>>>>>
>>>>>
>>>>>
>>>
>>
>>
>

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@discussions.microsoft.com> wrote in message
news:11AE0781-4E0A-491A-A0B9-CF7A2C4FDEC6@microsoft.com...
> 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@discussions.microsoft.com> wrote in message
>> news:6AA961F4-498F-4147-8F5F-51197D0A2209@microsoft.com...
>> >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 spreadsheet, 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@discussions.microsoft.com> wrote in message
>> >> news:1112E42C-E15F-4F6D-9C2B-F3F197D8D1C3@microsoft.com...
>> >> >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?
>> >>
>> >>
>> >>
>>
>>
>>