> I have developed an access database that contains the
> scheduling information of our mainframe applications
> (Predecessors and Successors). what I am trying to do is
> find out what data Visio needs to draw a flowchart of the
> jobs using parent/child. I tried with Organization chart
> but this does not permit multiple parents to a child. I
> need to know what data has to be included in either a table
> or text file that Visio can use to draw my flow chart.

>-----Original Message-----
>Tony:

>Have you already seen this in help?

>Create a text (.csv or.txt) data file from which to

>On the Tools menu, point to Macros, point to Flowchart,
and then click
>Import Flowchart Data Wizard.
>On the first wizard page, click Next.
>On the second wizard page, click Enter data in a new text
file, and then
>click Next.
>On the third page, do one of the following:
>Click Next if your flowchart will use the Basic Flowchart
template.
>Click Use a Custom Template if you want to use shapes from
a different
>flowchart template. Click Browse to locate the template,
click Open, and
>then click Next.
>On the fourth wizard page, enter a name for the new data
file. Click the
>browse button and specify a location for the new file.
Click Save and then
>click Next.
>A text file opens that includes instructions for setting
up the data file.

>Read the instructions, and then type your data in the text
file. In the text
>file, on the File menu, click Save, and then click Exit.
>In Microsoft Visio, on the final wizard page, click
Finish.

>--
>--------------------------------------------
>Graham Wideman
>MS MVP for Visio
>Books:
>Visio 2000 Developer's Survival Guide
>Visio 2002 Developer's Survival Pack (with Tools)
>.... and resources for programmable diagramming at:
>http://www.diagramantics.com
>--------------------------------------------
>Unoffical Visio FAQ:
>http://www.diagramantics.com/diagenvs/visio/faq/index.htm

>(Remove the obvious to email me)
>---------------------------------------------


>> I have developed an access database that contains the
>> scheduling information of our mainframe applications
>> (Predecessors and Successors). what I am trying to do is
>> find out what data Visio needs to draw a flowchart of
the
>> jobs using parent/child. I tried with Organization chart
>> but this does not permit multiple parents to a child. I
>> need to know what data has to be included in either a
table
>> or text file that Visio can use to draw my flow chart.

>.

> Yes I have already seen this. What I need to know is what
> is required in the .txt or .xls file so that Visio is able
> to draw my flowchart without any manual intervention from
> me or my users. I am able to write VBA code if needed as I
> have written many Excel and Access VBA macros. I crerated a
> file showing the parent child relationship and brought into
> the orgchart but this does not work as a child cannot have
> more than one parent

> Thanks
> Tony
> >-----Original Message-----
> >Tony:

> >Have you already seen this in help?

> >Create a text (.csv or.txt) data file from which to
> generate a flowchart
> >On the Tools menu, point to Macros, point to Flowchart,
> and then click
> >Import Flowchart Data Wizard.
> >On the first wizard page, click Next.
> >On the second wizard page, click Enter data in a new text
> file, and then
> >click Next.
> >On the third page, do one of the following:
> >Click Next if your flowchart will use the Basic Flowchart
> template.
> >Click Use a Custom Template if you want to use shapes from
> a different
> >flowchart template. Click Browse to locate the template,
> click Open, and
> >then click Next.
> >On the fourth wizard page, enter a name for the new data
> file. Click the
> >browse button and specify a location for the new file.
> Click Save and then
> >click Next.
> >A text file opens that includes instructions for setting
> up the data file.

> >Read the instructions, and then type your data in the text
> file. In the text
> >file, on the File menu, click Save, and then click Exit.
> >In Microsoft Visio, on the final wizard page, click
> Finish.

> >--
> >--------------------------------------------
> >Graham Wideman
> >MS MVP for Visio
> >Books:
> >Visio 2000 Developer's Survival Guide
> >Visio 2002 Developer's Survival Pack (with Tools)
> >.... and resources for programmable diagramming at:
> >http://www.diagramantics.com
> >--------------------------------------------
> >Unoffical Visio FAQ:
> >http://www.diagramantics.com/diagenvs/visio/faq/index.htm

> >(Remove the obvious to email me)
> >---------------------------------------------


> >> I have developed an access database that contains the
> >> scheduling information of our mainframe applications
> >> (Predecessors and Successors). what I am trying to do is
> >> find out what data Visio needs to draw a flowchart of
> the
> >> jobs using parent/child. I tried with Organization chart
> >> but this does not permit multiple parents to a child. I
> >> need to know what data has to be included in either a
> table
> >> or text file that Visio can use to draw my flow chart.

> >.

>-----Original Message-----
>Tony:

>Just in case you missed this, I mentioned the *Flow chart*
wizard, and you
>are talking about having tried the *Org Chart* wizard,
which is indeed
>hierarchical.

>If Flowchart Wiz doesn't do what you want, then your task
basically
>involves:

>a) Iterate through the records in your database (use

>like in Access -- in fact you can write this in Access if
you want).

>b) Use the data to drop shapes on a Visio page

>c) Use the parent-child data to drop and glue Visio
connector shapes

>All of this is straightforward Visio VBA stuff -- you can
get a good run at
>it reading Developing Visio Solutions (online in the msdn
library
>documentation tree under Office Solutions Development).
Also available as a
>book.

>The hard part, however is figuring out the heuristics you
want for
>distributing the shapes on a page. This is not hard

>thinking :-)  You can get some assistance by using

>setting their routing style and then asking the

>it for you -- but mileage varies as to how desirable the
result.  Try it
>with some manually placed shapes first to get an idea of
how various
>parameters affect this function (details in Visio Help)

>Graham

>--------------------------------------------
>Graham Wideman
>MS MVP for Visio
>Books:
>Visio 2000 Developer's Survival Guide
>Visio 2002 Developer's Survival Pack (with Tools)
>.... and resources for programmable diagramming at:
>http://www.diagramantics.com
>--------------------------------------------
>Unoffical Visio FAQ:
>http://www.diagramantics.com/diagenvs/visio/faq/index.htm

>(Remove the obvious to email me)
>---------------------------------------------


>> Yes I have already seen this. What I need to know is
what
>> is required in the .txt or .xls file so that Visio is
able
>> to draw my flowchart without any manual intervention
from
>> me or my users. I am able to write VBA code if needed as
I
>> have written many Excel and Access VBA macros. I
crerated a
>> file showing the parent child relationship and brought
into
>> the orgchart but this does not work as a child cannot
have
>> more than one parent

>> Thanks
>> Tony
>> >-----Original Message-----
>> >Tony:

>> >Have you already seen this in help?

>> >Create a text (.csv or.txt) data file from which to
>> generate a flowchart
>> >On the Tools menu, point to Macros, point to Flowchart,
>> and then click
>> >Import Flowchart Data Wizard.
>> >On the first wizard page, click Next.
>> >On the second wizard page, click Enter data in a new
text
>> file, and then
>> >click Next.
>> >On the third page, do one of the following:
>> >Click Next if your flowchart will use the Basic
Flowchart
>> template.
>> >Click Use a Custom Template if you want to use shapes
from
>> a different
>> >flowchart template. Click Browse to locate the
template,
>> click Open, and
>> >then click Next.
>> >On the fourth wizard page, enter a name for the new
data
>> file. Click the
>> >browse button and specify a location for the new file.
>> Click Save and then
>> >click Next.
>> >A text file opens that includes instructions for
setting
>> up the data file.

>> >Read the instructions, and then type your data in the
text
>> file. In the text
>> >file, on the File menu, click Save, and then click
Exit.
>> >In Microsoft Visio, on the final wizard page, click
>> Finish.

>> >--
>> >--------------------------------------------
>> >Graham Wideman
>> >MS MVP for Visio
>> >Books:
>> >Visio 2000 Developer's Survival Guide
>> >Visio 2002 Developer's Survival Pack (with Tools)
>> >.... and resources for programmable diagramming at:
>> >http://www.diagramantics.com
>> >--------------------------------------------
>> >Unoffical Visio FAQ:

>http://www.diagramantics.com/diagenvs/visio/faq/index.htm

>> >(Remove the obvious to email me)
>> >---------------------------------------------


>> >> I have developed an access database that contains the
>> >> scheduling information of our mainframe applications
>> >> (Predecessors and Successors). what I am trying to do
is
>> >> find out what data Visio needs to draw a flowchart of
>> the
>> >> jobs using parent/child. I tried with Organization
chart
>> >> but this does not permit multiple parents to a child.
I
>> >> need to know what data has to be included in either a
>> table
>> >> or text file that Visio can use to draw my flow
chart.

>> >.

>.