Creating and controlling wiring chart in Visio from Excel database

Started by ssimlai, May 07, 2017, 03:54:24 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

ssimlai

Hello,

I am new to the forum and thanks for welcoming me in.

I have a peculiar issue to resolve for which I would love to hear any possible. I have a home recording studio with a lot of stuff around and a complex audio wiring system that is about 70% well documented. I also have the set up on Visio but there are no linkages between the excel file and the Visio file.

What I would like to do is to link up the two, not just from an asset point of view which is easy as has been documented on MS website, but to go a step further. I would like to use wire numbers such <assetA><number><assetB> in excel and wish to see a connection between assets A and B drawn up automatically through the Data Menu.

Hoping there is someone out there who has already mastered it.
Sumit Simlai
Electrical & Electronics Engineer