motomarzel
New Member
- Joined
- Jul 6, 2021
- Messages
- 1
- Office Version
- 2013
- Platform
- Windows
Hi to everybody.
I am trying to create Excel based Invoice and Packing list. And I want to be able to automaticaly check the VAT numbers of the customer with VIES, collect the company data from there and fill it in dedicated cells.
For example:
I am typing the VAT number of the customer in one cell (C3) and the country code in another (B3), we have our company (requester) VAT in F3 and G3. Then I press a call button (which is invisible when printing) that runs macro, which checks with VIES database and returns Company name in cell (C4) and Address in another (C5). If the VAT is not valid, then it returns "Not Valid VAT" in C4 (company name field).
That thread might be helpful:
VBA IE automation
Thanks for the help in advance!
I am trying to create Excel based Invoice and Packing list. And I want to be able to automaticaly check the VAT numbers of the customer with VIES, collect the company data from there and fill it in dedicated cells.
For example:
I am typing the VAT number of the customer in one cell (C3) and the country code in another (B3), we have our company (requester) VAT in F3 and G3. Then I press a call button (which is invisible when printing) that runs macro, which checks with VIES database and returns Company name in cell (C4) and Address in another (C5). If the VAT is not valid, then it returns "Not Valid VAT" in C4 (company name field).
That thread might be helpful:
VBA IE automation
Thanks for the help in advance!