Data Import and Export Features in Visio 2016 (and 2013)

One of my most viewed articles is about the data import and export features in Visio 2010 (see https://blog.bvisual.net/2011/05/24/data-import-export-features-in-visio-2010/ ), so I thought that I should do something similar for Visio 2016. In fact, there is very little change since Visio 2013 …. The download file contains VBA code that I used to connect the shapes together from the data recordsets.

 

image

 

 

Click here to view the pdf : https://onedrive.live.com/redir?resid=3350D61BC93733A9!311121&authkey=!ADvirzitxZ2L8Xs&ithint=file%2cpdf

Click here to open the Visio file (contains macros) : https://onedrive.live.com/redir?resid=3350D61BC93733A9!308856&authkey=!AN4tW5sNpxSQFCM&ithint=file%2cvsdm

Click here to open the Excel workbook : https://onedrive.live.com/redir?resid=3350D61BC93733A9!306454&authkey=!AHms1XGHhXvXdwY&ithint=file%2cxlsx

 

The content will also form part of the new book that I am writing about mastering data with Visio….

Advertisements

4 Responses to “Data Import and Export Features in Visio 2016 (and 2013)”

  1. Using multiSelect in Visio | bVisual - for people interested in Microsoft Visio Says:

    […] have had some comments that the diagram in my previous post ( see https://blog.bvisual.net/2015/11/16/data-import-and-export-features-in-visio-2016-and-2013/ ) was a little hard to follow. May I suggest my free multiSelect add-in can help?  ( see […]

  2. Philippe LE PAGE Says:

    Hi David

    If I understand correctly, the difference/improvement you have with the Visio 2010 example is that now you have the automatic connection between shapes (with the VBA code) ? Does it mean that you have to manually connect the shapes with Visio 2010 ?

  3. Updating data sources from #Visio using #MSFlow … easily! | bVisual - for people interested in Microsoft Visio Says:

    […] the easiest no-code method of extracting data from a diagram is the Shape Reports (see Data Import and Export Features in Visio 2016 (and 2013) ), which can be found on the Review tab. This can be used to read the shapes on a page, or pages, […]


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Simplify Tasks

Want to learn the simple way?

Paul Turley's SQL Server BI Blog

sharing my experiences with the Microsoft data platform, SQL Server BI, Data Modeling, SSAS Design, Power Pivot, Power BI, SSRS Advanced Design, Power BI, Dashboards & Visualization since 2009

John Goldsmith's visLog

be smart, be clear, be visual ...

Mo's blog

Personal views on Dynamics 365 for Operations and Technical Architecture.

Chris Webb's BI Blog

Microsoft Power BI, Analysis Services, MDX, DAX, M, Power Pivot and Power Query

davecra.wordpress.com/

Microsoft Office 365 Development, and more...

PowerShell.Amsterdam

Automate, Accelerate, Accurate

johnvisiomvp

Life with Visio and other Microsoft Toys!

Title (Required)

Windows Server Essentials Tips & Tricks

Nilsandrey's Weblog

Just another WordPress.com weblog

Things that Should be Easy

Every so often (too often in the IT industry) I encounter things that should have been very easy to do but turned out to be far too complicated. My favorite topics include SharePoint, .Net development, and software architecture, especially distributed systems.

Visio Guy

Smart graphics for visual people

Pluralsight blog

be smart, be clear, be visual ...

%d bloggers like this: