Quote:
Originally Posted by KiwiJochen
Just as easy:
1. Copy latitude column
2. Paste into POI Maker latitude column
Repeat for Longitude and for Name
Add any other desired data
Very easy.
|
it very easy indeed, but when you open the .asc file it is not yet divided in column and you have to do it; then you have to convert numbers or the format does not work. My intent is to create a macro that:
- takes the full string from the single row;
- divides string into column (at least lat, long and names)
- converts lat and long in the appropriate format (divide by 1000000 and put 6 decimals)
- moves the column in the appropriate column of POI maker