Hi Moshe,

Thanks a lot. It worked like a charm! As only me will probably use it there is no need of a DBox. I did make a few modifications to fit my requirements. The most important was the following line(s):

//    for inner_loop = 1 to point_count do // Start looping over points a second time (for "to" point)
    for inner_loop = 1 to outer_loop do // Start looping over points a second time (for "to" point)

To get rid of the redundancy, the only problem is that I need now to have the ID sorted increasing but repeating the FROMID:
1,1
1,3
1,4
etc.
But I have
1,1
3,1
3,3
4,1
4,3
4,4
That is the same but not what required. I am thinking how to solve this chalenge now.

Best regards. And thanks again.

Reinaldo




[EMAIL PROTECTED] wrote:

I wrote a macro for this very function about a year ago... free
download at http://www.directionsmag.com/files/index.php/view/738

No dialog box, though-- you'll have to modify the administrative
settings at the top of the file. Either that, or commission someone to
write a dbox.

Quoting Reinaldo Paul Pérez Machado <[EMAIL PROTECTED]com.br>:

>
>
> Hi,
>
> Please, some help is required. I am not a DK programmer, but I need
> to generate a matrix containing all distances among 585 Lon/Lat
> coordinate pairs. That is, the resulting table should contain 170820
> values, if I am not calculating wrongly. I guess I should use the
> GetDistance() function, but the problem is I lack all the basic
> programming knowledge for sorting the results, write to a file etc.
> No fancy interface is required, but at least something like point to
> the .bin table or geographic file and asking for the name of the
> output would be necessary.
>
> Thanks in advance for the aid. Best regards,
>
> Reinaldo


__._,_.___

Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___

Reply via email to