Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Aug 2011
    Posts
    59
    Thanks
    23
    Thanked 2 Times in 2 Posts

    Export Visio text to Word or Excel

    I have a Visio file with many different tabs containing flow charts.

    I've searched for a macro routine to extract the text out of each page and keep them seperate but haven't found anything so far.

    Does anyone know where I can get such a VBA routine?

  2. #2
    4 Star Lounger petesmst's Avatar
    Join Date
    Dec 2009
    Location
    Cape Town, South Africa
    Posts
    507
    Thanks
    15
    Thanked 23 Times in 15 Posts
    Try one of these:

    You could use the Visio Shape Reports to extract the information into an Excel worksheet, and then copy to Word. Go to the Review tab, and select Shape Reports. If you are in a Flowchart, one of the options should be a Flowchart report, which will export several fields of data plus the text in the shapes. Select the Flowchart report, then click Run, and select Excel from the list of export types, and click OK. Excel will open with the information, including a column called "Displayed Text". (See this link): http://answers.microsoft.com/en-us/o...1-e740b4462c8e

    OR:
    try this link (Note, you can use the fully functional program for 30 "tries" free, but then it degrades. The add-on is expensive, but a fantastic asset to have with Visio): http://www.sandrila.co.uk/visio-utilities/


    OR: (These instructions are for Visio 2007.) http://kenfallon.com/getting-text-out-of-visio-drawings/


    1. Make a new report and select Shapes on All pages or Shapes on the current page.
    2. Then select only <Displayed Text> (you may want to Show all properties to make sure nothing else is checked)
    3. Give it a Title e.g: Text Only Report
    4. Give it a Name e.g: Text_Only_Report
    5. Then select run and export it to either Excel, HTML, Visio Shape or XML

    In the future when you want to extract text all you need to do is run Data -> Reports select Text_Only_Report and press Run.
    Last edited by petesmst; 2013-01-06 at 06:24. Reason: Added info about the cost of the add-on
    (My Setup: 3,70GHz Intel Core i7-4820K CPU; MSI Military Class iii X79A-GD45 Plus Motherboard; Win 8.1 Pro (64 bit); 16GB RAM; SAMSUNG SD840 PRO SSD (6GB/SATA III); Seagate 2TB Barracuda SATA6G HDD; GeForceGTX 760 2GB Graphics Card; Office 2013 Prof (32-bit); MS Project 2013 (32-bit); Acronis TI 2014 Premium, NIS 2014, etc). (UEFI-booted). WD My Book 3 1TB USB External Backup Drive)

  3. The Following User Says Thank You to petesmst For This Useful Post:

    jrb (2013-01-09)

  4. #3
    Star Lounger
    Join Date
    Aug 2011
    Posts
    59
    Thanks
    23
    Thanked 2 Times in 2 Posts
    Thanks Peter. This all worked out great.

Posting Permissions

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