VISIO Import Wizird

Started by AB@Onepiece, November 22, 2018, 07:55:12 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Print
Go Down Pages1
User actions

AB@Onepiece

November 22, 2018, 07:55:12 AM Last Edit: November 25, 2018, 07:49:15 PM by Visio Guy
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.??

Yacine

#1
November 22, 2018, 09:28:44 AM Last Edit: November 25, 2018, 07:48:55 PM by Visio Guy
What's wrong with the Import Data Wizard?
Yacine

JuneTheSecond

#2
November 24, 2018, 09:17:01 AM Last Edit: November 25, 2018, 07:49:06 PM by Visio Guy
Record your operation on Visio with Visio automatic macro writer.
Best Regards,

Junichi Yoda
http://june.minibird.jp/

wapperdude

#3
November 24, 2018, 03:36:13 PM Last Edit: November 25, 2018, 07:48:38 PM by Visio Guy
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=7302.0
http://visguy.com/vgforum/index.php?topic=7964.0

Wapperdude
Visio 2019 Pro
Print
Go Up Pages1
User actions