+ Reply to Thread
Results 1 to 1 of 1

MS visio 2003 & Excel 2007 [ replacing shape strings in visio by a excel lookup table ]

  1. #1
    Registered User
    Join Date
    12-11-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2007
    Posts
    3

    MS visio 2003 & Excel 2007 [ replacing shape strings in visio by a excel lookup table ]

    Hello,

    I'm having troubles with Visio and Excel. I've tried several techniques, but can't get it work together somehow.
    It doenst matter if the excel sheet is called as a file, or is 'integrated' in the visio drawing.

    What I want to do ;

    Replacing text strings in shapes from a certain layer within the VISIO drawing by looking up the same text string in a excel sheet. When it finds a match, replacing the text string in the VISIO shape with another text string found on the same row of the excel sheet.

    As example I have included a .VSD file (visio) with a sample excel object in it (* Rename the file Drawing001.vsd.xls to=> Drawing001.vsd)
    You see in the excel sheet 3 cells with ;
    'A'
    A1 : Symbol001
    A2 : Symbol002
    A3 : Symbol003

    'C'
    C1 : 2000.00
    C2 : 2000.01
    C3 : 2000.02

    In the VISIO drawing I have 3 shapes with text.
    Symbol001
    Symbol002
    Symbol003

    Now I want to replace the strings of the VISIO shapes with the strings found in the excel sheet. As simple as that...
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Link from Excel to MS Visio
    By hege11 in forum Excel General
    Replies: 15
    Last Post: 10-11-2015, 07:43 PM
  2. excel (col & row) to Visio (drawing)
    By sanlen in forum Excel General
    Replies: 0
    Last Post: 01-12-2011, 11:47 PM
  3. Integration of Excel 2007 and Visio 2007
    By wilro85 in forum Excel General
    Replies: 1
    Last Post: 07-03-2008, 12:40 PM
  4. Import from Excel to Visio 2003
    By Jehan in forum Excel General
    Replies: 0
    Last Post: 03-13-2008, 06:54 AM
  5. Ms Visio/excel
    By PoolMan in forum Excel General
    Replies: 8
    Last Post: 05-03-2007, 06:16 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1