Author Topic: Automatic filling data fields  (Read 2768 times)

0 Members and 1 Guest are viewing this topic.

Amin

  • Newbie
  • *
  • Posts: 2
Automatic filling data fields
« on: July 11, 2012, 03:36:30 AM »
Hello everybody,

I represent a processus on Visio 2010. 
I have to put in each task's data fields successors an predecessors of the task.
I want to know if it's possible to automatically fill the data field with the information on the connector between tasks.

Exemple:



Thank you for your help.
« Last Edit: July 11, 2012, 03:47:28 AM by Amin »

Jumpy

  • Hero Member
  • *****
  • Posts: 1061
Re: Automatic filling data fields
« Reply #1 on: July 11, 2012, 05:19:54 AM »
It is possible to write VBA-Code that does what you want, either everytime a connection is made or (maybe easier) once in one pass when the drawing is done. Here are some articles that should get you started:

http://www.visguy.com/2009/04/22/analyze-connectivity-between-process-flows/

http://www.visguy.com/2009/04/08/path-analysis-in-visio/


Or if you wan't do do it the other way:

http://www.visguy.com/2009/07/13/automatically-number-connect-shapes-with-code/


hth Jumpy

Amin

  • Newbie
  • *
  • Posts: 2
Re: Automatic filling data fields
« Reply #2 on: July 11, 2012, 09:49:21 AM »
Thank you for your help!

I managed to do what I wanted based on your usefull links.
I think this topic should be deplaced in the VBA forum

You will find my .vsd files in attachement with the VBA code.
« Last Edit: July 11, 2012, 10:25:10 AM by Amin »