Create a project to trap data from the website that gives the weather and images all in VBA
Good morning my name is A.Maurizio
And my pronoun and this: About an Excel sheet in Nella (H1) Enter the name of an Italian site such as (Turin)
After that: I would like the program to get the name of this location; Interrogate the Site in question to position itself on the page in question, but never open it and insert in each specific cell the Images derived from that Web Page.
Now I'm saying that I would have already solved some passages like getting the images from the site.
Now I just have to figure out how to get all the first part, and it was also possible to speed it up.
Now regarding this Site this and its LINK: (https://www.worldweatheronline.com/)
And as for my Test Project, you can download it from this Link: https://app.box.com/s/eoojl1slv5lrl3ww02e9b737i0b04zs2
Thank you for all the help you will be able to give me about Greetings and a Good Weekend by A.Maurizio
They provide weather data in JSON and XML.
XML can be parsed in VBA using MSXML2.DOMDocument. Read how to parse JSON in VBA here - https://codingislove.com/excel-json/
Hi ranjithkumar10 I thank you for your suggestions but for me your method remains a bit complicated because the link you suggested to me is very fragmented, here for how I am put and of little use.
However I prefer to continue on my own path, too, I understand that it is all up.
Thanks anyway for your help.
Sincerely greetings from A.Maurizio
@A-Maurizio I have implemented a similar weather API in excel. I'll write a tutorial about it soon but meanwhile, you can have a look at the file - https://drive.google.com/file/d/0B_N4BSTIGRZLLUhLVXBwY0x3YTQ/view?usp=sharing
Here's the tutorial - Fetching weather data in Excel VBA