refresh shape custom properties through VBA

C

ChatsAde

In Visio 2002 I have set up a database connection between a Visio drawing and
Excel. The Excel spreadsheet contains both shape properties (line width, fill
color) and custom properties.

I can manually refresh the properties of a shape to synchronise with the
Excel database by right clicking the shape object and choosing Refresh Shape
Properties. However I have a lot of shapes in my drawing, so would like to
automate this process.

I have written VBA code to manipulate shape properties, but cannot find a
method which will perform a "Refresh Shape Properties" instruction.

Can anybody help with how to do this?

Thanks

Ade
 
M

Mark Nelson [MS]

Look in the Shapesheet of one of these shapes and find the Actions section.
Look for the RUNADDON call that is made when you choose the Refresh Shape
Properties menu item. You should be able to make a similar call in your
code with the Addon.Run method.
 
Top