I got a project in which I have to perform following actions
1. Import the excel data (There are two sheets in which all the data is present let's say "Sheet-1" and "Sheet-2")
2. Then I need to select rectangle as the shape along with I need to label with "Name"
3. Need to select the unique ID with" ID"
4. Then rectangles show be populated to VISIO Sheet.
In simples terms, I need to create a macro which does similar actions as "Import Data Wizard". Can anyone help me with this.??
What's wrong with the Import Data Wizard?
Record your operation on Visio with Visio automatic macro writer.
The following links might be useful, both deal with getting custom info from excel into Visio.
http://visguy.com/vgforum/index.php?topic=7450.0 (http://visguy.com/vgforum/index.php?topic=7450.0)
http://visguy.com/vgforum/index.php?topic=7302.0 (http://visguy.com/vgforum/index.php?topic=7302.0)
http://visguy.com/vgforum/index.php?topic=7964.0 (http://visguy.com/vgforum/index.php?topic=7964.0)
Wapperdude