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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Visio shape text disappears upon copy paste 1
Adding connection points to shapes manually/programmatically 0
VBA - (re-) Set a Table Style 2
How to "Refresh Shape Properties" in VB Programming? 0
How to "Refresh Shape Properties" in VB Program. 4
refresh shape properties macro 1
Shape dragging problems with rack-mounted equipment in Visio 2007 1
Accessing custom properties on drop 3

Top