Hello,

My PM dump me whole network design in excel sheet and wants me to generate all network diagram in  MS Visio within a single click. 

Here is the scenario. There are  several network nodes with unique node ID . These nodes  are interconnected with unique Link ID with its own parameter. for example ,  A -> B -> C -> D -> E -> A  This is one ring.  There may be some nodes connected to  any of these node , for example c -> F -> G. This is open ended. We have several rings for one cluster.

Now we need  Visio diagrams with unique shape for sites on Ring or sites on open system. Also link has  to be assigned with different shapes based on link capacity. Also, data for each links has to be displayed . There has to be connection strings for excel or database as data keeps changing as design is still under process.

We can not do this manually as the number of nodes are around 3000.  I was told that this can be done either with Visio VBA coding or C++. I am familiar with T-SQL to some extend but never touched VBA scripts.

I will be greatful if somebody help me with these coding or recommend where to start from.  I can provide some sample data if you needed.

This weeked is going to be nightmare for me as this is due on Monday. 

Serious reply only , no BS please.

Thanks

- NF