Results 1 to 1 of 1

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

Threaded View

  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

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