need a vba/visio mentor for a project

[disciple]

Hi:

I have been asked to develop a vba/visio solution that
takes a visio diagram, adds shapes to it , deletes shapes
from it, and changes text labels of shapes, all driven
from changes to a database repository. This database
contains all the shapes in the diagram, and so when a
new shape is added to the database , the new shape
should also be added to the diagram. These are the
requirements in its simplest form.

the first phase of this to build the database, and
populate it from the existing diagram. This I can handle.

the 2nd phase is to build a solution which automatically
maintains the information in the diagram, as described in
my 1st paragraph above. I am new to VBA. If anyone is
interested in helping me with this project, acting as a
mentor role, please email me as soon as possible.

If there are better places that I should post my request
to, please also let me know.


I am using visio 2002, and Office XP SP1.

thanks so much...

disciple

(e-mail address removed)

 

[John Marshall, MVP]

Your best starting point is to obtain a copy of Developing Visio Solutions.
It does not have to be latest copy since the features you need have been in
Visio for a while. DVS is available as part of the online version of MSDN
and as a book from Microsoft Press. In earlier versions of Visio it was
available on the CD as an Acrobat file called DVS.PDF.

The things to look for in DVS are:
Examples of using events so that when items are dropped on the Visio drawing
or deleted Visio can update the database.
Examples of calling Visio from another program so that when the database is
updated, the drawing can be updated. Alternatively, When you open the Visio
drawing, you can run code to verify that the Visio drawing matches the
database.

Of course, you still have access to this newsgroup for questions.

John... Visio MVP

Need stencils or ideas? http://www.mvps.org/visio/3rdparty.htm
Need VBA examples? http://www.mvps.org/visio/VBA.htm
Common Visio Questions http://www.mvps.org/visio/common_questions.htm

 

[Billy Pruchno]

-----Original Message-----
Hi:

I have been asked to develop a vba/visio solution that
takes a visio diagram, adds shapes to it , deletes shapes
from it, and changes text labels of shapes, all driven
from changes to a database repository. This database
contains all the shapes in the diagram, and so when a
new shape is added to the database , the new shape
should also be added to the diagram. These are the
requirements in its simplest form.

the first phase of this to build the database, and
populate it from the existing diagram. This I can handle.

the 2nd phase is to build a solution which automatically
maintains the information in the diagram, as described in
my 1st paragraph above. I am new to VBA. If anyone is
interested in helping me with this project, acting as a
mentor role, please email me as soon as possible.

If there are better places that I should post my request
to, please also let me know.


I am using visio 2002, and Office XP SP1.

thanks so much...

disciple

(e-mail address removed)
.
Send me an email and we can discuss. Please visit our

website at visimation.com . My name is Billy.