Shapes shifting when I use Refresh Data

[Twixman23]

I am currently tracking inventory and when there is one item in a certain space, the object aligns in the dead center, but when there are two or more items in that certain space, the items stack next to each other(using the YAxis), which is a good thing, but the bad thing is all those shapes in the space move 2ft to the left automatically, so they are now not centered in the space shape.
Is there a way to make a general for loop that will find all the computer shapes in the document, find all the spaces these shapes refer to and make a formula, maybe using the PinX to align the shapes to the center of the space? I don't know how to reference the space since I imported the data into Visio. I imported the spaces first, then imported the computers and referenced the spaces from the first import and placed in the document.

Any suggestions? I will keep researching this to see if I can find out something.

thanks!!!
Twixman

 

[Twixman23]

I ended up using the VBA code to delete the certain shapes and refresh the data. My next question: When the data is refreshed, the Refresh Data summary window pops up. Is there a way to automatically click the OK button or even better to make that summary window not show? I don't want to have to get a person to click the ok button on the Summary window everytime the data is refreshed.

Any ideas?

Thanks for all your help!

Twixman

 

[Twixman23]

I wanted to add some clarification to my last post. Are there any command line parameters for the Refresh Data addon like there are for the SaveAsWeb addon such as /silent /folder etc.

Twixman