We help IT Professionals succeed at work.

Can Excel auto-generate a Visio Diagram?

tmonteit
tmonteit asked
on
Medium Priority
657 Views
Last Modified: 2008-02-01

A row in my excel file would represent one object in my diagram.    I would like to live-link between the two.

Can this be done without Lots of VBA?

Example?
Comment
Watch Question

Freelance
Top Expert 2006
Commented:
Hello tmonteit,

no code but some structured thinking will do :)

1. build a spreadsheet
2. export that to text or csv
3. import into visio

sample: http://www.boxesandarrows.com/view/automating_diagrams_with_visio

hope this helps a bit
bruintje

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Brian MulderFreelance
Top Expert 2006

Commented:
oh now i see the live link, then you will need code

1. a button on the worksheet which calls the export to file
2. a button in visio which will call the import

you are doing this for a presentation?

Author

Commented:
Working a collaborative design diagram.  The other guy keeps changing the excel spreadsheet.  I need to keep my diagram up to date.
Brian MulderFreelance
Top Expert 2006

Commented:
ok, what about the article is that something you can use?

it means that your partner needs to export a sheet from his workbook that is formatted the way visio will be able to like it for a diagram

Commented:
Visio is not something to just automatically pump a lot of things into. I'd rather still do it manually and have more personal control on the horizontal and vertical. Copy|paste work fine, so one you have a general structure, you can probably to it manually quicker than you could by any automation, which is to liable to miss some issues in balance and alignment, not to mention the margins

Commented:
>  a collaborative ...

er, make the other person update the Visio - if it is collaboration
Brian MulderFreelance
Top Expert 2006

Commented:
would be nice to have some user feedback

Author

Commented:
The link to boxes and arrows was most helpful.  
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.