Removing Database Link

[RM]

I have about 20 pages in Visio that get their custom properties from
an Excel spreadsheet through ODBC using the Database Wizard to link them.
Now I'm having trouble because I changed one of the column headings in the
excel spreadsheet and the visio custom properties are not refreshing
properly. It leaves the old property there. Since I have a bunch of these
to update I'd like to ask for help with little vb code. I know I could go
shapesheet to shapesheet and delete the row but it seems that a simple For
loop would work so much easier. I even tried re-linking all the shapes on a
page and only using one of the excel columns and it still doesn't delete the
old custom properties in Visio. Thanks for everyone's help.

 

[JuneTheSecond]

If you are having and using master shapes in your drawing stencil, they
should be modified as same as the shapes are modified in your drawing.

 

[RM]

Oh, now you tell me about the wonders of master shapes! LOL
Seriously, I didn't know much about visio when I started so now I have
20 pages of these shapes (approx 50/pg). If I could even just get the code
to check
for the existence of the offending row and delete it I would be happy. I
don't have the code in front of my that I've been playing with but basically
it's a function called RemoveDBLink. It declares shpObj as type shape. For
every shape on active page check for "Prop.HardDriveSizeMB29". If exists then
shpObj.deleterow(visSectionProp, 2). problem comes in right here because it
wants to set this last part = to something. seems like it should just do
what it says and delete the row. Thanks.