creation of a visio from excel spreadsheet via VB automation

[Visio Automation with VB]

I need to create a pert chart from data in an Excel Spreadsheet.
Can anyone share basic automation code and basic methodlogy with me?

Any help is appreciated.

Thanks

Tony

[news.microsoft.com]

Hi Tony,

You're kind of asking for two whole books with that short question, but here
are some pointers.

For Excel automation, start with the macro recorder to get a feel for how
Excel code looks and works. Visio has a macro recorder too.

For a fairly simple Visio tutorial on how to programmatically create
diagrams using VBA, check out my article:
Create Visio Flowcharts Programmatically
http://www.visguy.com/2006/09/13/create-visio-flowcharts-programmatically/
--
Hope this helps,

Chris Roth
Visio MVP

For in-depth Visio articles, Visio tutorials and free Visio shapes, stencils
and templates, check out my web site:

Visio Guy
http://www.visguy.com

For more Visio discussion, visit our forum (complete with pictures and
downloads!):

Visio Guy Forum
http://www.visguy.com/vgforum




"Visio Automation with VB" <Visio Automation with

Post by Visio Automation with VB
I need to create a pert chart from data in an Excel Spreadsheet.
Can anyone share basic automation code and basic methodlogy with me?
Any help is appreciated.
Thanks
Tony