Import flowchart from excel

[PeterS]

Hi,

I use Office 2003: I would like to import the data for a flowchart from an
excel sheet or access datatable. I read that I need the SDK, so I installed
it and under File/new/sdk I can run an example of what I want. But the big
question: how can I use it for my purposes. I can't see any reference in the
macros or in the add-on section.

 

[Chris Roth [MVP]]

Hi Peter,

You can link individual shapes to data in an Excel spreadsheet by fiddling
with a few of Visio's Add-ons. Look in Tools > Add-ons > Visio extras and
you'll see

- Database Wizard
- Link to Database

Also, if you have Visio Pro, then there's Import Data under Tools > Add-ons

Building Plan.

I believe you can hook to Excel for all of these, but you might have to set
your .xls up as a data source first.

If you think you'll still need to program, then check outmy tutorial on
generating Visio flowcharts programmatically. There's a Visio file with VBA
code that creates a flowchart. You can pick apart the code and learn from
that:

http://www.visguy.com/2006/09/13/create-visio-flowcharts-programmatically/

--
Hope this helps,

Chris Roth
Visio MVP

More Visio shapes, articles, development info and pure diagramming fun at:
www.visguy.com

 

[PeterS]

Chris,

thank you for the ideas, I will definitevely try to programm this, but I use
Delphi 7 so I need some time to translate and to try it.
But in the Visio 2003 SDK is a solution allready implemented, the only point
is I don't know how to use.
I've visio 2003 Pro SP2 german version, there I could not find anything like
import building plan. Please give me further details.

--
Thank you very much

PeterS

Hi Peter,

You can link individual shapes to data in an Excel spreadsheet by fiddling
with a few of Visio's Add-ons. Look in Tools > Add-ons > Visio extras and
you'll see

- Database Wizard
- Link to Database

Also, if you have Visio Pro, then there's Import Data under Tools > Add-ons

Building Plan.

I believe you can hook to Excel for all of these, but you might have to set
your .xls up as a data source first.

If you think you'll still need to program, then check outmy tutorial on
generating Visio flowcharts programmatically. There's a Visio file with VBA
code that creates a flowchart. You can pick apart the code and learn from
that:

http://www.visguy.com/2006/09/13/create-visio-flowcharts-programmatically/

--
Hope this helps,

Chris Roth
Visio MVP

More Visio shapes, articles, development info and pure diagramming fun at:
www.visguy.com