Hello, I'm attempting to design a somewhat complicated interface diagram using MS Visio. I would like my diagram to display the various interfaces between applications, and have an excel spreadsheet that contains the interface details (i.e., connection settings, frequency, host name, etc...) to support the diagram. When the user performs a mouse over of the interface in visio I would like a screen tip to pop up with the details stored in the spreadsheet for that interface. The details may contain different fields for each interface, I would like to be able to update the spreadsheet and automatically have the screen tips populated (I may have to write some VB for this). Further I would like to double click the interface and be taken to the excel details for that interface.
If it makes it easier, I'm OK embedding the visio diagram in the excel workbook.