Visio Guy

Visio Discussions => Programming & Code => Topic started by: breital on January 19, 2018, 04:56:57 AM

Title: Connecting inserted excel table with its source
Post by: breital on January 19, 2018, 04:56:57 AM
Hey guys,

actually I presently have to work with Visio 2010 to create flow chart structures for my company.
The aim is to create a new connected flow chart structure where shapes are connected to each other
but also to extern data sources like e.g. excel sheets.

At the moment I'm facing the following problem:
I created a table on excel and just pasted it into Visio.
Now I'd really like to connect them with each other, so that e.g if I change any data at the Excel sheet, it also
changes at the concerning cell in Visio.

Just found a couple of vba codes. But no suitable one for this situation.
Are there any options in visio itself or with vba?
Have not that much experience in programming...  ::)

Thanks for your help! :)
Title: Re: Connecting inserted excel table with its source
Post by: metuemre on January 19, 2018, 11:01:47 AM
Check this tool by Nikolay,

http://unmanagedvisio.com/products/visio-back-sync/ (http://unmanagedvisio.com/products/visio-back-sync/)