Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Linking Visio to MIMS via connector

Status
Not open for further replies.

oz1

Technical User
Sep 11, 2000
28
0
0
AU
Hi
I'm interested in finding out if any one has been able to link an object wit in a Visio drawing to a MIMS record. For example you have a network diagram and it shows a server in Visio. The user is able to click on that server, go though the MIMS login process and then be shown the servers details in the MIMS equipment register
 
I've done some development using Connector with Excel, but haven't used Visio (other than the following experiment). Most of the VBA code which you use in Excel can be copied and pasted to Visio.
For me, the tricky bit was to identify the "selected shape", and found that ActiveWindow.Selection(1) seems to work. I've stored the MIMS Equipment No in the Data1 property of each shape (Right-Click - Format - Special). I also used Name and ObjectType properties to do some checking.
For each of the shapes in the drawing, change their double-click behaviour to run a new sub. (Right-Click - Format - Behaviour - Double-Click Tab - Run Macro - ThisDocument.MIMS_Equip_Detail). Seems to work OK.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top