Id like to use excel for an automation project of mine and I'm sure it can be done as i've see something similar before but it was on a presentation so i do not have access to the file unfortunately.
Id like excel to hit a website and return the data based on on every combination of x length digit number.
The site is https://ec.europa.eu/taxation_customs/dds2/eos/eori_validation.jsp?Lang=en
and when it is hit with a search it is this https://ec.europa.eu/taxation_customs/dds2/eos/eori_validation.jsp?Lang=en&EoriNumb=GB340031366000&Expand=true showing the returned information of this Request date 23/10/2020 This EORI number is valid.
EORI Name LANDGEFLUGEL FG VERTRIEBSGESELLSCHAFT MBH Address name
Street number HERRN DIPL-KFM KORNSTRASSE 3 49716 Postal code City - Country name Germany
How do I use excel to auto return and populate my sheet with the information shown. The variable in this situation is the GB XXXXXXXXX 000, The GB and the 000 are always constant but the 9 digits change and are unique each time.
Can this be done or is this too much for excel?
Aucun commentaire:
Enregistrer un commentaire