creation of a visio from excel spreadsheet via VB automation

  • Thread starter Visio Automation with VB
  • Start date


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.





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

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

For more Visio discussion, visit our forum (complete with pictures and

Visio Guy Forum

"Visio Automation with VB" <Visio Automation with
(e-mail address removed)> wrote in message
news:[email protected]

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads