creation of a visio from excel spreadsheet via VB automation

  • Thread starter Visio Automation with VB
  • Start date

V

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
 
Ad

Advertisements

N

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
(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


Top