Can Excel auto-generate a Visio Diagram?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Working a collaborative design diagram. The other guy keeps changing the excel spreadsheet. I need to keep my diagram up to date.
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
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
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
> a collaborative ...
er, make the other person update the Visio - if it is collaboration
er, make the other person update the Visio - if it is collaboration
would be nice to have some user feedback
ASKER
The link to boxes and arrows was most helpful.
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?