LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Excel table to a flowchart

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create a Word Table from a Excel Macro Silvia Excel Discussion (Misc queries) 0 September 7th 06 12:34 AM
Macro to Extract Text From Word Table Into Excel? V. Hatherley Excel Discussion (Misc queries) 1 August 27th 06 04:12 PM
Publishing a Table in Excel 2007 (Beta 2) to a SharePoint List R3nReno Excel Discussion (Misc queries) 0 August 2nd 06 05:33 PM
Specifying table in Excel 2002 web queries claytorm Excel Discussion (Misc queries) 0 July 31st 06 03:37 PM
Linking table in Excel to word travis Links and Linking in Excel 1 November 19th 05 02:30 PM


All times are GMT +1. The time now is 09:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"