Find/Replace For Custom Properties

[dmyers]

Hello,

I have quite a problem.  I need to edit about 100 Visio files by changing over 2000 custom properties.  Each custom properties has the same string of only a few characters that I need to change.  Since Visio does not do a Find and Replace for custom properties I was hoping someone could help me out.  Going in manually will take me about a week, so I was hoping to find some code to do this in only an afternoon.

I am not very familiar with VBA so I am unable to write the code on my own.  Is there anyone who will be able to help me out and give me a few guidelines on how to work the coding.

Thanks,

djmyers

[JuneTheSecond]

Excel has such functions.
Visio 2007 profesional has the function to link excel or other database.
You can import and export custom properties data between Visio and Excel.
More information may be found at
http://office.microsoft.com/en-us/visio/HA101656401033.aspx
or any other related sites.

[dmyers]

Thanks JuneTheSecond,

This morning before I saw your reply I actually converted a Visio file to XML and use a Find and Replace program to change the custom properties I needed.  It looks like everything worked doing that.  I will be doing a few more test to make sure but I think that will be the way I go.

In addition does anyone know of a program/VBA script where I can mass convert my .vsd's to .vdx then back again?

Thanks,

djmyers

[JuneTheSecond]

Did you read this site?
http://msdn.microsoft.com/en-us/library/bb743267.aspx