Updating Shape Data Fields with Excel File and VB

Started by viki, December 14, 2011, 08:32:41 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

viki

I am trying to create a module in VB, which would retrieve the information from excel file and update specific shape data.  It is pretty easy to do the report and transfer all the shapes info from visio into excel sheet. But I am trying to the vise verse - update the report data and put it back to the shapes. Would anyone one how to do that?


aledlund

#1
viki,
this project does round tripping between access and a drawing

http://visguy.com/vgforum/index.php?topic=2298.msg10100#msg10100

this one has examples for between the drawing and excel

http://www.visguy.com/2009/04/08/path-analysis-in-visio/

al