Excel VBA code to input data into website and then return the result.

[excli23456]

Hi all,

I am trying to create some Excel VBA code to automate finding out the distance from coast of 3000 sets of co-ordinates that I have in Excel, my VBA knowledge is very limited.
I am planning on using the following website and was wondering if anyone had any idea of how to automate this process using VBA on Excel, or point me in the right direction.
Distance to coast

Thanks

 

[Legacy 143009]

Some mathematician would be better for this. But with my limited geometry knowledge, I would write a formula like below:
min(destination_pointX-target_datasetX)²+min(destination_pointY-target_datasetY)²=routute²

 

[Legacy 143009]

My first suggestion won't work since it will cobine any X point with any Y point. But each coordinate has specific X/Y points. I will prepare an example for you. I have something in mind. It is a bit heuristic but will work.

 

[Legacy 143009]

Sometimes I like my self. Please like me

Find Closest Distance.xlsm

1 file sent via WeTransfer, the simplest way to send your files around the world

we.tl

 

[Legacy 143009]

Some major bugs fixed:

Find Closest Distance Final.xlsm

1 file sent via WeTransfer, the simplest way to send your files around the world

we.tl

 

[Legacy 143009]

But I think this is not the thing you are after. You are looking for a solution to run this file on the website. This won't be a practical application.
A better solution would be to read CSV file and convert it to json via JS and make the necessary calculations inside the browser with JS. Which are not the scope of this forum. I can help you further if you write from private messaging.
Also, I am sharing the optimized version of my file for 3000 rows:

WeTransfer | Send Large Files Fast - Up To 2GB Free

The simple, quick and secure way to send your files around the world without an account. Share your files, photos, and videos today for free.

we.tl

But I don't think there is a practical way to run this file on a website.