Return Data from Specific URL from Cell in Worksheet

[rafilip]

I believe I have thoroughly researched this question (sorry if you have seen the answer, please be patient with me).
Truly a newcomer to VBA/Macros and do not even fully understand where to "put" the codes that are provided in these message boards, that is why I prefer a formula.
My sheet has cells which feed to a hyperlink (i.e. A1=JFK, B1=CVG, C1=HYPERLINK("Great Circle Mapper"&A1&"-"&B1,"My Flight").
If you visit the link (Great Circle Mapper) it shows the flying distance between these two points - 589 mi.
What I am trying to do is do a web query in Excel based off the link provided in cell C1, and then have the web query point to the total distance included in the link - and then populate another cell on my sheet (D1) with that distance.
Any and all help would be appreciated!

n.b. - posted this on another message board several months ago, it got removed, now reposted there and posted here as well - sorry if it's a duplicate - if I have to, I will remove from other forum.

 

[Rijnsent]

Hi rafilip,
there is code available to automate webqueries straight from Excel from VBA, see e.g. this question which has quite some bits you can use:
http://www.mrexcel.com/forum/excel-...eck-website-values-update-cells-workbook.html
Hope that gets you started,
Cheers,
Koen

 

[rafilip]

Hi rafilip,
there is code available to automate webqueries straight from Excel from VBA, see e.g. this question which has quite some bits you can use:
http://www.mrexcel.com/forum/excel-...eck-website-values-update-cells-workbook.html
Hope that gets you started,
Cheers,
Koen

Thank you so much @Rijnsent, however, being the absolute buffoon that I am with VBA - I can not even begin to follow that logic.

 

[Rijnsent]

Hi rafilip,
mmm, okay, I don't have time for it now, but can try to see if I can create some code. Another solution: create for yourself a table of airports you use with lat&lon, use a VLOOKUP to lookup the lat & lon and then calculate the distance in Excel:
http://www.mrexcel.com/forum/excel-...ce-between-two-latitude-longitude-points.html
It only requires a bit of manual labour to collect the lat & lon of all the airports, no VBA whatsoever .
Cheers,
Koen