Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Viso Interface Diagram with supporting data

Posted on 2009-04-08
8
Medium Priority
?
1,685 Views
Last Modified: 2012-05-06
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.
0
Comment
Question by:JamesCbury
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
8 Comments
 
LVL 31

Expert Comment

by:Scott Helmers
ID: 24103898
What you're describing is feasible but it will take a bit of creativity and may require some VB code as you suggest. A couple of initial thoughts:
  • You don't mention what version of Visio you have but you want Visio 2007 Professional for what you have in mind. In particular, this will be much easier using the data linking features in 2007 Pro rather than the clunky database links in prior versions. Updates to the data in the spreadsheet can be pushed to the drawing manually or at a preset time interval. Start here if you're not familiar with data linking:
         http://office.microsoft.com/en-us/visio/HA100487831033.aspx
  • Tooltip text does work in Visio but Visio truncates what it will display; you'll need to experiment to see how much you can fit that's useful. From the Visio UI, use Insert/Shape ScreenTip to try it (we can get the text into the appropriate place automatically from the spreadsheet too, though that will require an extra trick or two).
  • Hyperlinking so a doubleclick opens the spreadsheet is very doable; in fact, you can create a hyperlink that opens the worksheet at a specific cell or cell range and highlights it.
  • You don't need to embed the drawing in the Excel workbook; at the moment I can't think of any advantage to doing so.
That's all I have time for at the moment, but just wanted to let you know that what you're describing can be done, probably with very little need for code. (Having said, that all of the above can be automated also, if that turns out to be desirable.)
0
 
LVL 31

Expert Comment

by:Scott Helmers
ID: 24137111
James,

Was the information above helpful? What else do you need to get started on your interface diagram?

Scott
0
 

Author Comment

by:JamesCbury
ID: 24138956
Hi, sorry for the delay in my response.  The info above helped me get a good start... Unfortunatly I'm stuck with MS Vision 2003, So I have to use the older data link functions.  I may for-go the screen tips and just use hyper links to my excel sheet.
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 
LVL 31

Expert Comment

by:Scott Helmers
ID: 24140200
Sorry about Visio 2003 :-(    It will definitely still work to link to Excel, it's just more work for you.

For the hyperlinks, if you want the link to highlight a specific cell when someone follows it, there are two steps: 1) create the named cells or cell ranges in Excel; 2) when you create the hyperlink in Visio, enter the target cell/range name in the Subaddress field in the hyperlink dialog. When someone follows your link, the named cell/range will be highlighted.

Re the tooltip: when you create the link to Excel, if you create a custom property field in the shape that is populated with data from the cell containing the text you want in the tooltip, the rest is easy. For example, if your custom property field is called XYZ then open the shapesheet and type this is the Comment cell in the Miscellaneous section
   =Prop.XYZ
The tool tip text will appear. (OK, there is one complication -- if the same shape also has a hyperlink, the tooltip for the hyperlink trumps the Comment and only the hyperlnk description appears. But there's an easy way around that also... let me know if you want the details.)

Let me know if you need anything else...
0
 

Author Comment

by:JamesCbury
ID: 24142855
Hi Scott, the tool tip trick would be pretty helpful, right now when I scroll over the linked shape all I an see is the spreadsheet name...

-Thanks,
0
 
LVL 31

Expert Comment

by:Scott Helmers
ID: 24143904
Do you have a custom property field in the shape that now contains the text you want to appear in the tooltip as I described above? If so, open the shapesheet and put the same formula from above
   =Prop.XYZ
into the Description field of the hyperlink row. (If you're not familiar with editing shapesheets, let me know).

If you have lots of shapes for which you need to do this, I can write a 10-line macro that will make this change on all shapes...
0
 
LVL 31

Accepted Solution

by:
Scott Helmers earned 1500 total points
ID: 24697219
James,

Are you all set on this question or do you need additional information?

Scott
0
 

Author Closing Comment

by:JamesCbury
ID: 31568292
Sorry Scott, I've been away from this for a while... thanks for the help
0

Featured Post

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question