How You Can Bulk Validate VAT Numbers (macro in excel)

Dear All,

could you please share with me working macro to be used in excel for validation of EU VAT numbers per batch?

Examples to be validated:

Tax ID
IT00851460154
M200821408
FR69316853332
BE0406762669
BE0400622470
BE0425815647
BE0458777138
BE0439752567
BE0404636389
BE0429096029
BE0431049588
DE140127410
DE277644461
DE141737497
DE140362638
DE153551436

There was such formula shared by Watersev in the thread of angeloo, title: Macro to check VAT Numeber, but I get an error, when I try to use it.
Can anybody help with that?

Many thanks in advance!

Greetings,

Please note that the VIES server is only an "intermediary". The databases of relevant countries are polled. When we receive the answer "Unverified", it may mean that the server of the given country is not responding or the VIES server is overloaded. These numbers should be checked again in a while.
Great Britain is no longer being verified.
Efficiency, depending on the bandwidth and load - about 130-180 identifiers per minute.

Since Sucuri Website Firewall did not allow the code to be published, I included it in the attachment.

Artik

Hi Artik,

thank you for your answer and explanation. But file which you uploaded does not seem to contain macro. It is just a list of the VAT numbers, I think. Could you please check if you uploaded correct file?
Many thanks in advance!

Greetings,
Broagn

BTW: I am actually also from Poland, just living in NL.

I checked. Everything is fine with the file.

When you download a file from the Internet or an e-mail client (Outlook), the file is often blocked by the system to protect your computer. When you open a file, a yellow bar with warnings appears below the ribbon. First warning - You must agree to edit this file. Second warning - you must agree to run the macros. When you agree to edit and run the macros, then press the keyboard shortcut LAlt + F8. The macro name "Test" should appear on the list. Run them.

Artik

Dear Artik

Thank you very much for this great macro.

I would also like to call up the "traders" names and addresses. (see below)

Is it possible to add this macro?

BR / Thomas

<xsd:element name="countryCode" type="xsd:string"/>
<xsd:element name="vatNumber" type="xsd:string"/>
<xsd:element name="requestDate" type="xsd:date"/>
<xsd:element name="valid" type="xsd:boolean"/>
<xsd:element maxOccurs="1" minOccurs="0" name="traderName" nillable="true" type="xsd:string"/>
<xsd:element maxOccurs="1" minOccurs="0" name="traderCompanyType" nillable="true" type="tns1:companyTypeCode"/>
<xsd:element maxOccurs="1" minOccurs="0" name="traderAddress" type="xsd:string"/>
<xsd:element maxOccurs="1" minOccurs="0" name="traderStreet" type="xsd:string"/>
<xsd:element maxOccurs="1" minOccurs="0" name="traderPostcode" type="xsd:string"/>
<xsd:element maxOccurs="1" minOccurs="0" name="traderCity" type="xsd:string"/>
<xsd:element maxOccurs="1" minOccurs="0" name="traderNameMatch" type="tns1:matchCode"/>
<xsd:element maxOccurs="1" minOccurs="0" name="traderCompanyTypeMatch" type="tns1:matchCode"/>
<xsd:element maxOccurs="1" minOccurs="0" name="traderStreetMatch" type="tns1:matchCode"/>
<xsd:element maxOccurs="1" minOccurs="0" name="traderPostcodeMatch" type="tns1:matchCode"/>
<xsd:element maxOccurs="1" minOccurs="0" name="traderCityMatch" type="tns1:matchCode"/>

i trie this, but

EL 090049628 Invalid VAT number
ES 00000005M Unverified

PT 195412613 - its valid, mas the macro in excel is invalid

Dear Artik,

I just tried out your macro after downloading the file: VAT IDs Verification.
The macro runs without any errors but the result is "Invalid VAT number" for all 84 records.
Do you have an idea why I get this result ?
Your feedback is very much appreciated.

Best regards
Kim

There was a slight change in the VIES server response, hence the problems with incorrect results.
Attached is the new version.

Artik

Thank you very much
It is working now :-)
Kim

Dear Artik,

I have used this code to run with little changes that include picking data from specific cells.

.Open "POST", "weblink", False
.Send (Soap)

At this line of code, I'm getting the error "Access is Denied". I have tried updating the link of VIES but no luck. please help

Thanks in advance.

Hi Artik, thanks for your help, are you available at all please?

I've tried to run this but it's saying Invalid VAT number even on VAT numbers I know are correct? Is there something else I need to do other than paste in the country code and VAT number?

eg.
GB 455585025
GB 150484032

I guess you forgot that GB left the EU. The VIES system verifies the IDs of EU members only.

Artik

Originally Posted by Artik

I guess you forgot that GB left the EU. The VIES system verifies the IDs of EU members only.

Artik

ahh yes, good point thank you!

My Dear Friends,

The file is unparalleled! But is it possible to add the VAT number of the entity requesting the VAT number to the formula and the ConsultationNumber appears in the result? Attachment 815398Attachment 815399

I am honestly new to VBA and find it difficult to grasp the language even from scratch I hope you will support me

Kamila