Adding/changing data to shapes

[Paul K]

So I have added data to shapes that were linked to an excel file. What I
would like to be able to do with VBA is read the data that is attached to the
shape. I am doing a lot of searching and cannot find the method to call and
return the data linked on a shape. Any help?

Thanks,
Paul

 

[John Goldsmith]

Hello Paul,

Take a look at John Marshall's site: http://visio.mvps.org/VBA.htm

There's a good example for you about a third of the way down the page called
'Custom Properties' (what 'Shape Data' used to be called).

Best regards

John

John Goldsmith
www.visualsignals.co.uk

 

[Al Edlund]

Just as a caution if you're using the v2007 datalinking function, it is
pretty much designed as a one way path; i.e. you can easily read information
from a datasource and refresh from the datasource. It doesn't have an easy
mechanism to send back to a datasource other than XML.
al