MapForums

Hi ,

I have developped a vba code that creates a "pavement" of shapes (rectangles) on a map to cover it without empty spaces.

There is a dataset of locations (pushpins) in this map, and I want to know which pushpins are within which shape.

All should work fine using the QueryShape method over each shape, but I found out that a few pushpins are not returned by the method although I can see they are well within a shape. The "export to Excel" command doesn't function either (I have a "no data found" message)

If I move slightly (even by 1 pixel) the shape then it works again... But I have hundreds of shape, and don't want to move them all to make it work..

Has anyone had such a problem??

Thanks in advance

Hi,
As a workaround you could move all shapes in your code a little if that gives a solution.

__________________
rgds, Wilfried Mestdagh
www.mestdagh.biz
www.comfortsoftware.be
www.expertsoftware.be
MapPoint coding demo

Hi thanks for your answer, I tried to create my shapes in 2 steps : 1st at MyMap.getlocation(0,0), and 2nd to place them at the right location.

It doens't work, some pushpins in some shapes are still missed, and again if I move a shape within which it happened with my mouse it works again... It's crazy.

I don't know how I can make programmaticaly an action equivalent as "moving around a little bit with my mouse"

Any idea welcome,

Regards

Hi,

get the Location of it. modify latitude or longitude of it and then again. this should do the same as what you do with the mouse.

__________________
rgds, Wilfried Mestdagh
www.mestdagh.biz
www.comfortsoftware.be
www.expertsoftware.be
MapPoint coding demo

I didn't know it was possible to get the latitude and longitude coordinates of a location...

But I googled again on my problem and found a reference to a similar problem. The answer given was another piece of code doing the same, but using a Polylines object instead of a Shape.

And that works just fine !

... my conclusion is that there is a bug with the Shape objects

Anyway now I have to find ways to calculate the area of my polylines, but I'm confident it is feasible.

Thanks