Create an Excel Macro that will generate a KML file to be imported into MyMaps

Closed Posted 7 years ago Paid on delivery
Closed Paid on delivery

Create an Excel macro that will generate a KML file to be imported into Google MyMaps from a data file that I will provide.

Whilst my data file will change from day to day, within it there are three fields of interest.

Location Name

Latitude and Longitude

Location Code

The macro must generate the KML file that when imported into Google MyMaps, will plot a series of Geo Tags.

Each Geo Tag must be named according to the Location Name in the file.

Each Tag must be positioned according to the corresponding latitude and longitude.

Each Tag must be coloured and ordered according to the Location Code*.

* A note on the Location Code.

The format will be XXX-YYYY. Eg. 001-0020

Where

XXX = Group

YYYY = Order within the group

All locations that have the same Group number must have the same Geo Tag Colour.

This Colour should be settable within dialog box interface or similar.

All locatons within the same Group must be ordered ascending numerically according to the YYYY component.

The Groups should also be ordered ascenging numerically

Example:

McDonalds Auburn (Blue Geo Tag) 001-0010

McDonalds Parramatta (Blue Geo Tag) 001-0021

Mcdonalds Hurstville (Yellow Geo Tag) 002-0010

Excel Google Maps API

Project ID: #13891250

About the project

16 proposals Remote project Active 6 years ago

16 freelancers are bidding on average $434 for this job

schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex More

$450 AUD in 4 days
(139 Reviews)
6.4
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$500 AUD in 5 days
(146 Reviews)
6.5
DeepSyaal

Lets start. Having a team of Professionals. We provide high quality work with accuracy. Would you like to discuss more about your current requirements?

$277 AUD in 3 days
(180 Reviews)
6.3
avinav606lx

Hi there, I am an Excel Macro expert with over 7 years of experience. The project looks interesting. Let's discuss more on chat. Thanks Avinav

$250 AUD in 2 days
(101 Reviews)
6.0
emamulbd

Dear Client, Your job posting catches my attention and I submit the proposal as a desired candidate. I'm a full time freelancer experienced in Lead Generation, Virtual Assistant, PDF conversation, Social Media Marke More

$555 AUD in 10 days
(14 Reviews)
4.5
surekash7096

I have the expertise in Excel VBA and can do this task, as per requirements, quickly and accurately. Ready to start work immediately.

$250 AUD in 5 days
(62 Reviews)
5.1
Vasilchenko

Hello I can do this. The task is clear. Let discuss details about format of data you have and I may start..............................

$300 AUD in 4 days
(35 Reviews)
4.9
ifriends710

Hello. I am a GIS expert and Web&Mobile(iOS&Android) developer. Since 10 years before I have been developing GIS applications. I graduated GIS special education course and I have rich experiences for development More

$700 AUD in 10 days
(4 Reviews)
4.9
asin1987

Dear Employer, I will automate the process for you using VBAs and MAcros. Please find attached my previous work samples. Please let me know if we can discuss further on this. You can add me on s*k*y*p*e as well More

$555 AUD in 10 days
(8 Reviews)
4.1
huongth

Hi. I am an expert in VBA, VBScript, Visual Basic, C#, F#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, fo More

$750 AUD in 3 days
(3 Reviews)
1.8
Vipunen

Hi, interesting project. How fixed is the requirement to do this in Excel Macro? I've converted few very similar macros from customers to HTML+Javascript and it's been generally a very liked solution. Basicly a loca More

$400 AUD in 7 days
(2 Reviews)
1.0
ketas

- Have read your detail specification and know what you want. Could do it for you right now. - I'm data engineer with many experience working with VBA on MS Excel - Did some tool related to GPS by using VBA - Since More

$250 AUD in 0 days
(2 Reviews)
0.4
XCraft21

Hello. Only result can prove everything. I don’t want to explain about my skills to you in a long way. You are probably looking for a way to do exactly your project. And you will be asking for a freelancer that can be More

$555 AUD in 10 days
(0 Reviews)
0.0
rkowalski

Hi, Your project is very intersting and challenging, I like it! I'm an expert in Excel and have done a lot of Macros for different purpose. It will be a pleasure to help you in your project. Please fill free to More

$333 AUD in 4 days
(0 Reviews)
0.0