Auto Refresh Shape Properties when data changed

[Shely E]

I have a visio drawing embeded into my application (using ActiveX)
I want the custome properties value of shapes in the drawing (linked to
database records) to be able to refresh itself whenver data in the linked
table changes.
How to go about doing it?

 

[Al Edlund]

check for either the formula changed or cell changed event and then fire
off the database update (ado, dao, etc.)
al

 

[Shely E]

I think you get me wrong. Updating of database records is done by a seperate
module.

The visio drawing is use to display the status/stage of the data in database
and the drawing is readonly. I need the visio drawing to be able to refesh
the content of its linked data on a certain interval.

 

[Shely E]

I have found how to auto-refresh data at a pre-defined interval.
Tools/Add-Ons/Visio Extra/Database setting.

Now my problem is that the shapes color represent status of the records.
For example: Green = Active, Red = Cancel, Yellow = On-Hold
How do I also refresh the shape color automatically as well?

 

[Al Edlund]

there are examples on John Marshall's site (www.mvps.org\visio)
al

 

[Shely E]

Could you point me to the address that has the specific articles. I found
some articles on how to use the color value add on but you still need to
right click on the Legend and select Refresh Legend. What I want is
automatically change of shape color during database refresh.
Or how to incoporate a macro that does that in the database refresh event?
(Is there such even?)

 

[Al Edlund]

If I was looking for an eas(ier) way to do it I would check out this
http://office.microsoft.com/en-us/assistance/HP010385231033.aspx.
I would then start recording a macro 1.) refresh a shape, 2.) update the
shape color
using the procedure above. This should give you a quick look at the how the
addins
are called.
al