latitude/longitude From Excel?

In another post by Somar in http://board.flashkit.com/board/showthread.php?t=666832 he posted a file called map.fla.
That file explaned how to move an object usinig latitudes and longitudes. It does this by using the following code

// Change these to whatever you want to see.
Desired_Latitude = 51.5;
Desired_Longitude = 30.5;


That works fine but the problem is that i have about 100 or more latitudes and longitudes position for that same object so it is very time consuimg if i entered them all manually using that method. IS there anyway i can read the longitudes and latitdues from the excel file instead of manually inserting one by one?

Dont think you can from an excel file but you can from a text file or an xml file.

Hope it help

Would u happen to know how by anychance?

check the flash doc for working with external data

hope it helps

you can save you excel sheet to a delimited character file and import it that way separating your data (lat/lon) by that character..

you could then dump all the values into an array & just loop through it.. plotting your markers (moving your object)

or as an xml file from excel as well... excel xml is really messy though.. so u will need to create a mapping in excel ..which maps to that data
this may help get you started:

http://msdn.microsoft.com/en-us/libr...gscenarios_map