A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Powerpoint, Publisher and Visio » Visio
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Automatically Linking Multiple Shapes



 
 
Thread Tools Display Modes
  #1  
Old August 7th, 2008, 01:58 PM posted to microsoft.public.visio.general
BenMcD
external usenet poster
 
Posts: 14
Default 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
...
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
...
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
...
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
...
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

  #2  
Old August 8th, 2008, 09:33 AM posted to microsoft.public.visio.general
David Parker
external usenet poster
 
Posts: 467
Default 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
...
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
...
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
...
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
...
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
...
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

  #3  
Old August 8th, 2008, 09:54 AM posted to microsoft.public.visio.general
BenMcD
external usenet poster
 
Posts: 14
Default 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
...
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
...
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
...
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
...
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
...
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


  #4  
Old August 8th, 2008, 07:37 PM posted to microsoft.public.visio.general
David Parker
external usenet poster
 
Posts: 467
Default Automatically Linking Multiple Shapes

nothing has arrived ... davidp at bvisual.net ?

"BenMcD" wrote in message
...
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
...
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
...
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
...
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
...
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
...
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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:45 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.