Author Topic: VISIO Import Wizird  (Read 338 times)

0 Members and 1 Guest are viewing this topic.

AB@Onepiece

  • Newbie
  • *
  • Posts: 1
VISIO Import Wizird
« on: November 22, 2018, 02:55:12 AM »
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.??
« Last Edit: November 25, 2018, 02:49:15 PM by Visio Guy »

Yacine

  • Hero Member
  • *****
  • Posts: 2580
Re: VISIO Import Wizard
« Reply #1 on: November 22, 2018, 04:28:44 AM »
What's wrong with the Import Data Wizard?
« Last Edit: November 25, 2018, 02:48:55 PM by Visio Guy »
Yacine

JuneTheSecond

  • Hero Member
  • *****
  • Posts: 1027
    • Visio Shapes, Stencils and Sample Drawings
Re: VISIO Import Wizard
« Reply #2 on: November 24, 2018, 04:17:01 AM »
Record your operation on Visio with Visio automatic macro writer.
« Last Edit: November 25, 2018, 02:49:06 PM by Visio Guy »
Best Regards,

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

wapperdude

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 3481
  • Ideas Visio-lized into solutions
Re: VISIO Import Wizard
« Reply #3 on: November 24, 2018, 10:36:13 AM »
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
« Last Edit: November 25, 2018, 02:48:38 PM by Visio Guy »
Visio 2019 Pro