|
|
|
date: Thu, 7 Aug 2008 05:58:13 -0700,
group: microsoft.public.visio.general
back
Automatically Linking Multiple Shapes
Hi all,
I've already posted this question on here, to which I received very helpful
replies. But wondered if I could call on your services and expertise once
again. I updated my old post, but looks like no-one's noticed it. See below...
---------
Unforunately I'm back to ask your advice again- I've cracked getting Visio
to link shapes. It looks at the particular shape, examines a field called
'Parent', takes the name of the parent, locates it then connects the two
together. I can't seem to work out how to get it to connect a shape to
mutliple parents!
My parent field would be as follows:
Parent - SERVER1, SERVER 2, SERVER3
Each entity is followed by a comma and seperated by a space. How do I go
about modifying the code so that it can connect to multiple parents? I can
send the code if required?
Any advice/help you can provide would be greatly appreciated as I've been
struggling for some time!
Thanks again,
Ben
"David Parker" wrote:
> Glad you like the book ... shame it couldn't be in color!
>
> "BenMcD" wrote in message
> news:2FA32EE6-77E1-4D58-8BDF-62CA4A17A3D3@microsoft.com...
> > David,
> >
> > I've bought your book and have been working my way through it. Very good
> > read, there's so much I didn't realise you could do with Visio!
> >
> > I've started coding to get the shapes to link automatically, I'm modifying
> > the 'Connect my Subordinates' section to suit my needs. When I run it in
> > it's
> > standard form, it displays the following error:
> >
> > "Compile Error:
> > Type mismatch: array or user-defined type expected"
> >
> > The particular line is:
> > If FindMySubordinates(manager, foundShapes) = True Then
> >
> > I'm not too sure where to go from here, any suggestions?
> >
> > Thank you,
> > Ben
> >
> > "David Parker" wrote:
> >
> >> Yes, with code, of course
> >>
> >> "BenMcD" wrote in message
> >> news:1E2E4680-388A-4323-A284-CECBC37065DD@microsoft.com...
> >> > Sounds like exactly what I need! Just to make it clear:
> >> >
> >> > Each of the component items within my DB are related to different
> >> > service
> >> > areas within my organisation. I could use the database wizard to
> >> > monitor
> >> > the
> >> > table and add the shapes automatically, copying the record details into
> >> > the
> >> > relevant custom property fields. Within a new custom property, each
> >> > item
> >> > would have the asset tag of the other equipment it's linked to- could
> >> > Visio
> >> > monitor this field, identify the asset tag of the related items, find
> >> > the
> >> > related items, and draw the links between them?
> >> >
> >> > Hopefully then it would be a case of setting Visio to auto-arrange the
> >> > shapes into a tree based layout.
> >> >
> >> > Does this sound 'do-able'?
> >> >
> >> > "David Parker" wrote:
> >> >
> >> >> The book is aimed at Visio 2007, but roughly half is applicable to
> >> >> Visio
> >> >> 2003.
> >> >> The connections example could be adapted to read any recordset, or the
> >> >> custom properties (which could be refreshed using the database wizard)
> >> >>
> >> >>
> >> >> "BenMcD" wrote in message
> >> >> news:EBBDE251-0854-4468-808B-EAE4AFAD6D42@microsoft.com...
> >> >> > Thanks for that Al, I'll do some googling and try and order a copy
> >> >> > of
> >> >> > the
> >> >> > book. Can this be done in any version of 2003? My organisation
> >> >> > doesn't
> >> >> > have
> >> >> > 2007 at the moment, but I can get a copy of it if it can't be done
> >> >> > in
> >> >> > 2003.
> >> >> >
> >> >> > "Al Edlund" wrote:
> >> >> >
> >> >> >> The easy first step is to get David Parkers book on data
> >> >> >> visualization.
> >> >> >> He
> >> >> >> has some examples on how to do the visio portion of it. The pre-req
> >> >> >> in
> >> >> >> this
> >> >> >> case if v2007 Pro for data linking. I usually strongly suggest that
> >> >> >> the
> >> >> >> user
> >> >> >> consider using o2007 pro as well even though a2007 isn't required.
> >> >> >> The
> >> >> >> skill set would be medium to strong vb(a) skills with some
> >> >> >> knowledge
> >> >> >> of
> >> >> >> database.
> >> >> >> If you need more help come on back,
> >> >> >>
> >> >> >> al
> >> >> >>
> >> >> >> "BenMcD" wrote in message
> >> >> >> news:7F9DE00D-E376-4C42-8B74-DFD7DE7C1415@microsoft.com...
> >> >> >> > Hi Everyone,
> >> >> >> >
> >> >> >> > I'm trying to get Visio to connect shapes automatically. The
> >> >> >> > process
> >> >> >> > should
> >> >> >> > be that Visio examines the 'Connected to' field of the shape,
> >> >> >> > locates
> >> >> >> > the
> >> >> >> > shapes in the drawing listed in this field using their Asset
> >> >> >> > Number,
> >> >> >> > then
> >> >> >> > draws connecting lines between the shape and it's children. So
> >> >> >> > for
> >> >> >> > example,
> >> >> >> > it would look at a Switch, recognise that 3 servers are connected
> >> >> >> > to
> >> >> >> > it,
> >> >> >> > locate these servers on the drawing, then add the connectors.
> >> >> >> >
> >> >> >> > Does anyone have any ideas how this could be done? I'm thinking
> >> >> >> > it's
> >> >> >> > going
> >> >> >> > to be a bit of VBA, but my knowledge is limited. My eventual plan
> >> >> >> > is
> >> >> >> > to
> >> >> >> > run a
> >> >> >> > database update, add the new shapes based on the Access records,
> >> >> >> > then
> >> >> >> > automatically link and layout the shapes to produce a Network
> >> >> >> > Toplogy
> >> >> >> > diagram.
> >> >> >> >
> >> >> >> > I'm sure it's possible, but I need advice from experts to help me
> >> >> >> > out!
> >> >> >> >
> >> >> >> > Thanks in advance,
> >> >> >> > Ben
date: Thu, 7 Aug 2008 05:58:13 -0700
author: BenMcD
Re: Automatically Linking Multiple Shapes
Sorry, I've been away on holiday...
In VBA, you can use the Split() function to create an array of parents, then
iterate the array to connect to multiple parents.
Send me your code direct if you want.
"BenMcD" wrote in message
news:91E9C63A-A172-4EF9-996F-E4DABC46C068@microsoft.com...
> Hi all,
>
> I've already posted this question on here, to which I received very
> helpful
> replies. But wondered if I could call on your services and expertise once
> again. I updated my old post, but looks like no-one's noticed it. See
> below...
>
> ---------
>
> Unforunately I'm back to ask your advice again- I've cracked getting Visio
> to link shapes. It looks at the particular shape, examines a field called
> 'Parent', takes the name of the parent, locates it then connects the two
> together. I can't seem to work out how to get it to connect a shape to
> mutliple parents!
>
> My parent field would be as follows:
> Parent - SERVER1, SERVER 2, SERVER3
>
> Each entity is followed by a comma and seperated by a space. How do I go
> about modifying the code so that it can connect to multiple parents? I can
> send the code if required?
>
> Any advice/help you can provide would be greatly appreciated as I've been
> struggling for some time!
>
> Thanks again,
> Ben
>
> "David Parker" wrote:
>
>> Glad you like the book ... shame it couldn't be in color!
>>
>> "BenMcD" wrote in message
>> news:2FA32EE6-77E1-4D58-8BDF-62CA4A17A3D3@microsoft.com...
>> > David,
>> >
>> > I've bought your book and have been working my way through it. Very
>> > good
>> > read, there's so much I didn't realise you could do with Visio!
>> >
>> > I've started coding to get the shapes to link automatically, I'm
>> > modifying
>> > the 'Connect my Subordinates' section to suit my needs. When I run it
>> > in
>> > it's
>> > standard form, it displays the following error:
>> >
>> > "Compile Error:
>> > Type mismatch: array or user-defined type expected"
>> >
>> > The particular line is:
>> > If FindMySubordinates(manager, foundShapes) = True Then
>> >
>> > I'm not too sure where to go from here, any suggestions?
>> >
>> > Thank you,
>> > Ben
>> >
>> > "David Parker" wrote:
>> >
>> >> Yes, with code, of course
>> >>
>> >> "BenMcD" wrote in message
>> >> news:1E2E4680-388A-4323-A284-CECBC37065DD@microsoft.com...
>> >> > Sounds like exactly what I need! Just to make it clear:
>> >> >
>> >> > Each of the component items within my DB are related to different
>> >> > service
>> >> > areas within my organisation. I could use the database wizard to
>> >> > monitor
>> >> > the
>> >> > table and add the shapes automatically, copying the record details
>> >> > into
>> >> > the
>> >> > relevant custom property fields. Within a new custom property, each
>> >> > item
>> >> > would have the asset tag of the other equipment it's linked to-
>> >> > could
>> >> > Visio
>> >> > monitor this field, identify the asset tag of the related items,
>> >> > find
>> >> > the
>> >> > related items, and draw the links between them?
>> >> >
>> >> > Hopefully then it would be a case of setting Visio to auto-arrange
>> >> > the
>> >> > shapes into a tree based layout.
>> >> >
>> >> > Does this sound 'do-able'?
>> >> >
>> >> > "David Parker" wrote:
>> >> >
>> >> >> The book is aimed at Visio 2007, but roughly half is applicable to
>> >> >> Visio
>> >> >> 2003.
>> >> >> The connections example could be adapted to read any recordset, or
>> >> >> the
>> >> >> custom properties (which could be refreshed using the database
>> >> >> wizard)
>> >> >>
>> >> >>
>> >> >> "BenMcD" wrote in message
>> >> >> news:EBBDE251-0854-4468-808B-EAE4AFAD6D42@microsoft.com...
>> >> >> > Thanks for that Al, I'll do some googling and try and order a
>> >> >> > copy
>> >> >> > of
>> >> >> > the
>> >> >> > book. Can this be done in any version of 2003? My organisation
>> >> >> > doesn't
>> >> >> > have
>> >> >> > 2007 at the moment, but I can get a copy of it if it can't be
>> >> >> > done
>> >> >> > in
>> >> >> > 2003.
>> >> >> >
>> >> >> > "Al Edlund" wrote:
>> >> >> >
>> >> >> >> The easy first step is to get David Parkers book on data
>> >> >> >> visualization.
>> >> >> >> He
>> >> >> >> has some examples on how to do the visio portion of it. The
>> >> >> >> pre-req
>> >> >> >> in
>> >> >> >> this
>> >> >> >> case if v2007 Pro for data linking. I usually strongly suggest
>> >> >> >> that
>> >> >> >> the
>> >> >> >> user
>> >> >> >> consider using o2007 pro as well even though a2007 isn't
>> >> >> >> required.
>> >> >> >> The
>> >> >> >> skill set would be medium to strong vb(a) skills with some
>> >> >> >> knowledge
>> >> >> >> of
>> >> >> >> database.
>> >> >> >> If you need more help come on back,
>> >> >> >>
>> >> >> >> al
>> >> >> >>
>> >> >> >> "BenMcD" wrote in message
>> >> >> >> news:7F9DE00D-E376-4C42-8B74-DFD7DE7C1415@microsoft.com...
>> >> >> >> > Hi Everyone,
>> >> >> >> >
>> >> >> >> > I'm trying to get Visio to connect shapes automatically. The
>> >> >> >> > process
>> >> >> >> > should
>> >> >> >> > be that Visio examines the 'Connected to' field of the shape,
>> >> >> >> > locates
>> >> >> >> > the
>> >> >> >> > shapes in the drawing listed in this field using their Asset
>> >> >> >> > Number,
>> >> >> >> > then
>> >> >> >> > draws connecting lines between the shape and it's children. So
>> >> >> >> > for
>> >> >> >> > example,
>> >> >> >> > it would look at a Switch, recognise that 3 servers are
>> >> >> >> > connected
>> >> >> >> > to
>> >> >> >> > it,
>> >> >> >> > locate these servers on the drawing, then add the connectors.
>> >> >> >> >
>> >> >> >> > Does anyone have any ideas how this could be done? I'm
>> >> >> >> > thinking
>> >> >> >> > it's
>> >> >> >> > going
>> >> >> >> > to be a bit of VBA, but my knowledge is limited. My eventual
>> >> >> >> > plan
>> >> >> >> > is
>> >> >> >> > to
>> >> >> >> > run a
>> >> >> >> > database update, add the new shapes based on the Access
>> >> >> >> > records,
>> >> >> >> > then
>> >> >> >> > automatically link and layout the shapes to produce a Network
>> >> >> >> > Toplogy
>> >> >> >> > diagram.
>> >> >> >> >
>> >> >> >> > I'm sure it's possible, but I need advice from experts to help
>> >> >> >> > me
>> >> >> >> > out!
>> >> >> >> >
>> >> >> >> > Thanks in advance,
>> >> >> >> > Ben
--
David Parker
Microsoft MVP (Visio)
http://bvisual.spaces.live.com
http://www.visualizinginformation.com
date: Fri, 8 Aug 2008 09:33:03 +0100
author: David Parker
Re: Automatically Linking Multiple Shapes
Thanks David, I've forwarded the code onto your email address, stored in your
profile on here.
"David Parker" wrote:
> Sorry, I've been away on holiday...
> In VBA, you can use the Split() function to create an array of parents, then
> iterate the array to connect to multiple parents.
> Send me your code direct if you want.
>
> "BenMcD" wrote in message
> news:91E9C63A-A172-4EF9-996F-E4DABC46C068@microsoft.com...
> > Hi all,
> >
> > I've already posted this question on here, to which I received very
> > helpful
> > replies. But wondered if I could call on your services and expertise once
> > again. I updated my old post, but looks like no-one's noticed it. See
> > below...
> >
> > ---------
> >
> > Unforunately I'm back to ask your advice again- I've cracked getting Visio
> > to link shapes. It looks at the particular shape, examines a field called
> > 'Parent', takes the name of the parent, locates it then connects the two
> > together. I can't seem to work out how to get it to connect a shape to
> > mutliple parents!
> >
> > My parent field would be as follows:
> > Parent - SERVER1, SERVER 2, SERVER3
> >
> > Each entity is followed by a comma and seperated by a space. How do I go
> > about modifying the code so that it can connect to multiple parents? I can
> > send the code if required?
> >
> > Any advice/help you can provide would be greatly appreciated as I've been
> > struggling for some time!
> >
> > Thanks again,
> > Ben
> >
> > "David Parker" wrote:
> >
> >> Glad you like the book ... shame it couldn't be in color!
> >>
> >> "BenMcD" wrote in message
> >> news:2FA32EE6-77E1-4D58-8BDF-62CA4A17A3D3@microsoft.com...
> >> > David,
> >> >
> >> > I've bought your book and have been working my way through it. Very
> >> > good
> >> > read, there's so much I didn't realise you could do with Visio!
> >> >
> >> > I've started coding to get the shapes to link automatically, I'm
> >> > modifying
> >> > the 'Connect my Subordinates' section to suit my needs. When I run it
> >> > in
> >> > it's
> >> > standard form, it displays the following error:
> >> >
> >> > "Compile Error:
> >> > Type mismatch: array or user-defined type expected"
> >> >
> >> > The particular line is:
> >> > If FindMySubordinates(manager, foundShapes) = True Then
> >> >
> >> > I'm not too sure where to go from here, any suggestions?
> >> >
> >> > Thank you,
> >> > Ben
> >> >
> >> > "David Parker" wrote:
> >> >
> >> >> Yes, with code, of course
> >> >>
> >> >> "BenMcD" wrote in message
> >> >> news:1E2E4680-388A-4323-A284-CECBC37065DD@microsoft.com...
> >> >> > Sounds like exactly what I need! Just to make it clear:
> >> >> >
> >> >> > Each of the component items within my DB are related to different
> >> >> > service
> >> >> > areas within my organisation. I could use the database wizard to
> >> >> > monitor
> >> >> > the
> >> >> > table and add the shapes automatically, copying the record details
> >> >> > into
> >> >> > the
> >> >> > relevant custom property fields. Within a new custom property, each
> >> >> > item
> >> >> > would have the asset tag of the other equipment it's linked to-
> >> >> > could
> >> >> > Visio
> >> >> > monitor this field, identify the asset tag of the related items,
> >> >> > find
> >> >> > the
> >> >> > related items, and draw the links between them?
> >> >> >
> >> >> > Hopefully then it would be a case of setting Visio to auto-arrange
> >> >> > the
> >> >> > shapes into a tree based layout.
> >> >> >
> >> >> > Does this sound 'do-able'?
> >> >> >
> >> >> > "David Parker" wrote:
> >> >> >
> >> >> >> The book is aimed at Visio 2007, but roughly half is applicable to
> >> >> >> Visio
> >> >> >> 2003.
> >> >> >> The connections example could be adapted to read any recordset, or
> >> >> >> the
> >> >> >> custom properties (which could be refreshed using the database
> >> >> >> wizard)
> >> >> >>
> >> >> >>
> >> >> >> "BenMcD" wrote in message
> >> >> >> news:EBBDE251-0854-4468-808B-EAE4AFAD6D42@microsoft.com...
> >> >> >> > Thanks for that Al, I'll do some googling and try and order a
> >> >> >> > copy
> >> >> >> > of
> >> >> >> > the
> >> >> >> > book. Can this be done in any version of 2003? My organisation
> >> >> >> > doesn't
> >> >> >> > have
> >> >> >> > 2007 at the moment, but I can get a copy of it if it can't be
> >> >> >> > done
> >> >> >> > in
> >> >> >> > 2003.
> >> >> >> >
> >> >> >> > "Al Edlund" wrote:
> >> >> >> >
> >> >> >> >> The easy first step is to get David Parkers book on data
> >> >> >> >> visualization.
> >> >> >> >> He
> >> >> >> >> has some examples on how to do the visio portion of it. The
> >> >> >> >> pre-req
> >> >> >> >> in
> >> >> >> >> this
> >> >> >> >> case if v2007 Pro for data linking. I usually strongly suggest
> >> >> >> >> that
> >> >> >> >> the
> >> >> >> >> user
> >> >> >> >> consider using o2007 pro as well even though a2007 isn't
> >> >> >> >> required.
> >> >> >> >> The
> >> >> >> >> skill set would be medium to strong vb(a) skills with some
> >> >> >> >> knowledge
> >> >> >> >> of
> >> >> >> >> database.
> >> >> >> >> If you need more help come on back,
> >> >> >> >>
> >> >> >> >> al
> >> >> >> >>
> >> >> >> >> "BenMcD" wrote in message
> >> >> >> >> news:7F9DE00D-E376-4C42-8B74-DFD7DE7C1415@microsoft.com...
> >> >> >> >> > Hi Everyone,
> >> >> >> >> >
> >> >> >> >> > I'm trying to get Visio to connect shapes automatically. The
> >> >> >> >> > process
> >> >> >> >> > should
> >> >> >> >> > be that Visio examines the 'Connected to' field of the shape,
> >> >> >> >> > locates
> >> >> >> >> > the
> >> >> >> >> > shapes in the drawing listed in this field using their Asset
> >> >> >> >> > Number,
> >> >> >> >> > then
> >> >> >> >> > draws connecting lines between the shape and it's children. So
> >> >> >> >> > for
> >> >> >> >> > example,
> >> >> >> >> > it would look at a Switch, recognise that 3 servers are
> >> >> >> >> > connected
> >> >> >> >> > to
> >> >> >> >> > it,
> >> >> >> >> > locate these servers on the drawing, then add the connectors.
> >> >> >> >> >
> >> >> >> >> > Does anyone have any ideas how this could be done? I'm
> >> >> >> >> > thinking
> >> >> >> >> > it's
> >> >> >> >> > going
> >> >> >> >> > to be a bit of VBA, but my knowledge is limited. My eventual
> >> >> >> >> > plan
> >> >> >> >> > is
> >> >> >> >> > to
> >> >> >> >> > run a
> >> >> >> >> > database update, add the new shapes based on the Access
> >> >> >> >> > records,
> >> >> >> >> > then
> >> >> >> >> > automatically link and layout the shapes to produce a Network
> >> >> >> >> > Toplogy
> >> >> >> >> > diagram.
> >> >> >> >> >
> >> >> >> >> > I'm sure it's possible, but I need advice from experts to help
> >> >> >> >> > me
> >> >> >> >> > out!
> >> >> >> >> >
> >> >> >> >> > Thanks in advance,
> >> >> >> >> > Ben
>
> --
> David Parker
> Microsoft MVP (Visio)
> http://bvisual.spaces.live.com
> http://www.visualizinginformation.com
>
>
date: Fri, 8 Aug 2008 01:54:03 -0700
author: BenMcD
Re: Automatically Linking Multiple Shapes
nothing has arrived ... davidp at bvisual.net ?
"BenMcD" wrote in message
news:3F8E9DE9-DD58-4405-8724-07796DADC30A@microsoft.com...
> Thanks David, I've forwarded the code onto your email address, stored in
> your
> profile on here.
>
> "David Parker" wrote:
>
>> Sorry, I've been away on holiday...
>> In VBA, you can use the Split() function to create an array of parents,
>> then
>> iterate the array to connect to multiple parents.
>> Send me your code direct if you want.
>>
>> "BenMcD" wrote in message
>> news:91E9C63A-A172-4EF9-996F-E4DABC46C068@microsoft.com...
>> > Hi all,
>> >
>> > I've already posted this question on here, to which I received very
>> > helpful
>> > replies. But wondered if I could call on your services and expertise
>> > once
>> > again. I updated my old post, but looks like no-one's noticed it. See
>> > below...
>> >
>> > ---------
>> >
>> > Unforunately I'm back to ask your advice again- I've cracked getting
>> > Visio
>> > to link shapes. It looks at the particular shape, examines a field
>> > called
>> > 'Parent', takes the name of the parent, locates it then connects the
>> > two
>> > together. I can't seem to work out how to get it to connect a shape to
>> > mutliple parents!
>> >
>> > My parent field would be as follows:
>> > Parent - SERVER1, SERVER 2, SERVER3
>> >
>> > Each entity is followed by a comma and seperated by a space. How do I
>> > go
>> > about modifying the code so that it can connect to multiple parents? I
>> > can
>> > send the code if required?
>> >
>> > Any advice/help you can provide would be greatly appreciated as I've
>> > been
>> > struggling for some time!
>> >
>> > Thanks again,
>> > Ben
>> >
>> > "David Parker" wrote:
>> >
>> >> Glad you like the book ... shame it couldn't be in color!
>> >>
>> >> "BenMcD" wrote in message
>> >> news:2FA32EE6-77E1-4D58-8BDF-62CA4A17A3D3@microsoft.com...
>> >> > David,
>> >> >
>> >> > I've bought your book and have been working my way through it. Very
>> >> > good
>> >> > read, there's so much I didn't realise you could do with Visio!
>> >> >
>> >> > I've started coding to get the shapes to link automatically, I'm
>> >> > modifying
>> >> > the 'Connect my Subordinates' section to suit my needs. When I run
>> >> > it
>> >> > in
>> >> > it's
>> >> > standard form, it displays the following error:
>> >> >
>> >> > "Compile Error:
>> >> > Type mismatch: array or user-defined type expected"
>> >> >
>> >> > The particular line is:
>> >> > If FindMySubordinates(manager, foundShapes) = True Then
>> >> >
>> >> > I'm not too sure where to go from here, any suggestions?
>> >> >
>> >> > Thank you,
>> >> > Ben
>> >> >
>> >> > "David Parker" wrote:
>> >> >
>> >> >> Yes, with code, of course
>> >> >>
>> >> >> "BenMcD" wrote in message
>> >> >> news:1E2E4680-388A-4323-A284-CECBC37065DD@microsoft.com...
>> >> >> > Sounds like exactly what I need! Just to make it clear:
>> >> >> >
>> >> >> > Each of the component items within my DB are related to different
>> >> >> > service
>> >> >> > areas within my organisation. I could use the database wizard to
>> >> >> > monitor
>> >> >> > the
>> >> >> > table and add the shapes automatically, copying the record
>> >> >> > details
>> >> >> > into
>> >> >> > the
>> >> >> > relevant custom property fields. Within a new custom property,
>> >> >> > each
>> >> >> > item
>> >> >> > would have the asset tag of the other equipment it's linked to-
>> >> >> > could
>> >> >> > Visio
>> >> >> > monitor this field, identify the asset tag of the related items,
>> >> >> > find
>> >> >> > the
>> >> >> > related items, and draw the links between them?
>> >> >> >
>> >> >> > Hopefully then it would be a case of setting Visio to
>> >> >> > auto-arrange
>> >> >> > the
>> >> >> > shapes into a tree based layout.
>> >> >> >
>> >> >> > Does this sound 'do-able'?
>> >> >> >
>> >> >> > "David Parker" wrote:
>> >> >> >
>> >> >> >> The book is aimed at Visio 2007, but roughly half is applicable
>> >> >> >> to
>> >> >> >> Visio
>> >> >> >> 2003.
>> >> >> >> The connections example could be adapted to read any recordset,
>> >> >> >> or
>> >> >> >> the
>> >> >> >> custom properties (which could be refreshed using the database
>> >> >> >> wizard)
>> >> >> >>
>> >> >> >>
>> >> >> >> "BenMcD" wrote in message
>> >> >> >> news:EBBDE251-0854-4468-808B-EAE4AFAD6D42@microsoft.com...
>> >> >> >> > Thanks for that Al, I'll do some googling and try and order a
>> >> >> >> > copy
>> >> >> >> > of
>> >> >> >> > the
>> >> >> >> > book. Can this be done in any version of 2003? My organisation
>> >> >> >> > doesn't
>> >> >> >> > have
>> >> >> >> > 2007 at the moment, but I can get a copy of it if it can't be
>> >> >> >> > done
>> >> >> >> > in
>> >> >> >> > 2003.
>> >> >> >> >
>> >> >> >> > "Al Edlund" wrote:
>> >> >> >> >
>> >> >> >> >> The easy first step is to get David Parkers book on data
>> >> >> >> >> visualization.
>> >> >> >> >> He
>> >> >> >> >> has some examples on how to do the visio portion of it. The
>> >> >> >> >> pre-req
>> >> >> >> >> in
>> >> >> >> >> this
>> >> >> >> >> case if v2007 Pro for data linking. I usually strongly
>> >> >> >> >> suggest
>> >> >> >> >> that
>> >> >> >> >> the
>> >> >> >> >> user
>> >> >> >> >> consider using o2007 pro as well even though a2007 isn't
>> >> >> >> >> required.
>> >> >> >> >> The
>> >> >> >> >> skill set would be medium to strong vb(a) skills with some
>> >> >> >> >> knowledge
>> >> >> >> >> of
>> >> >> >> >> database.
>> >> >> >> >> If you need more help come on back,
>> >> >> >> >>
>> >> >> >> >> al
>> >> >> >> >>
>> >> >> >> >> "BenMcD" wrote in message
>> >> >> >> >> news:7F9DE00D-E376-4C42-8B74-DFD7DE7C1415@microsoft.com...
>> >> >> >> >> > Hi Everyone,
>> >> >> >> >> >
>> >> >> >> >> > I'm trying to get Visio to connect shapes automatically.
>> >> >> >> >> > The
>> >> >> >> >> > process
>> >> >> >> >> > should
>> >> >> >> >> > be that Visio examines the 'Connected to' field of the
>> >> >> >> >> > shape,
>> >> >> >> >> > locates
>> >> >> >> >> > the
>> >> >> >> >> > shapes in the drawing listed in this field using their
>> >> >> >> >> > Asset
>> >> >> >> >> > Number,
>> >> >> >> >> > then
>> >> >> >> >> > draws connecting lines between the shape and it's children.
>> >> >> >> >> > So
>> >> >> >> >> > for
>> >> >> >> >> > example,
>> >> >> >> >> > it would look at a Switch, recognise that 3 servers are
>> >> >> >> >> > connected
>> >> >> >> >> > to
>> >> >> >> >> > it,
>> >> >> >> >> > locate these servers on the drawing, then add the
>> >> >> >> >> > connectors.
>> >> >> >> >> >
>> >> >> >> >> > Does anyone have any ideas how this could be done? I'm
>> >> >> >> >> > thinking
>> >> >> >> >> > it's
>> >> >> >> >> > going
>> >> >> >> >> > to be a bit of VBA, but my knowledge is limited. My
>> >> >> >> >> > eventual
>> >> >> >> >> > plan
>> >> >> >> >> > is
>> >> >> >> >> > to
>> >> >> >> >> > run a
>> >> >> >> >> > database update, add the new shapes based on the Access
>> >> >> >> >> > records,
>> >> >> >> >> > then
>> >> >> >> >> > automatically link and layout the shapes to produce a
>> >> >> >> >> > Network
>> >> >> >> >> > Toplogy
>> >> >> >> >> > diagram.
>> >> >> >> >> >
>> >> >> >> >> > I'm sure it's possible, but I need advice from experts to
>> >> >> >> >> > help
>> >> >> >> >> > me
>> >> >> >> >> > out!
>> >> >> >> >> >
>> >> >> >> >> > Thanks in advance,
>> >> >> >> >> > Ben
>>
>> --
>> David Parker
>> Microsoft MVP (Visio)
>> http://bvisual.spaces.live.com
>> http://www.visualizinginformation.com
>>
>>
--
David Parker
Microsoft MVP (Visio)
http://bvisual.spaces.live.com
http://www.visualizinginformation.com
date: Fri, 8 Aug 2008 19:37:18 +0100
author: David Parker
|
|
