Excel table to a flowchart

[Guest]

A solution to this problem alone will make Office worth the price for us.
We have a workflow in place. An Analyst will supply the QA group with a
visio diagram of the workflow, and the database developer with an excel file
of each status (decision box on the diagram) and each status available from
it.
For example, I can move work from a status of Open, to either Filed or
Pending. From Open, I need to have 3 statuses available, Open, Filed and
Pending. The spreadsheet woudl look something like this
Column 1 Column 2
Open Open
Open Filed
Open Pending

The Diagram is something like this:

Open ---->Pending
|
|
V
Filed

Is there a way, some privately developed piece of code even, to take this
excel file and generate the diagram?

Because the analyst has to create the same work twice, they often miss a
status or two when updating a workflow with 8 or 9 steps.

Thanks, Sean

 

[nhebb]

Sean,

I don't quite follow what you want to do. Did you want to update the
Excel file and have it propagate changes to the Visio diagram? I have a
product that generates flowcharts within Excel based upon the text
entered, but I'm not sure that it would be a good fit since the
flowchart generated would be created with MS Office AutoShapes.


Regards,

Nick Hebb
BreezeTree Software
http://www.breezetree.com

 

[nhebb]

Hmmm ... sounds like you need a custom programming solution, or better
yet, find an easier way to track the workflow.

- Nick