manka
03-29-2016, 08:04 AM
Hi there
I came across this website when I tried to find a solution to calling a webservice. In particular, the thread found by putting "36765 add a webservice reference to an excel 2010 sheet" into google. Unfortunately as a newbie I can't post direct links.
I would like to do something similar to check whether a VAT number is valid for a particular customer of the business.
The WDSL service can be found by typing checkVatService.wsdl into google (on vies website)
You are able to test the service using the details on the webpage found by typing "vies technical Information.html" into google
I wondered whether it is possible to incorporate the above into the code in the post referred to; I'd ideally like to check multiple VAT numbers at a time but not sure if its possible either?
Thanks for looking through. I'm just starting out with VBA so I'm sure I'll be back here again and again!!!
I came across this website when I tried to find a solution to calling a webservice. In particular, the thread found by putting "36765 add a webservice reference to an excel 2010 sheet" into google. Unfortunately as a newbie I can't post direct links.
I would like to do something similar to check whether a VAT number is valid for a particular customer of the business.
The WDSL service can be found by typing checkVatService.wsdl into google (on vies website)
You are able to test the service using the details on the webpage found by typing "vies technical Information.html" into google
I wondered whether it is possible to incorporate the above into the code in the post referred to; I'd ideally like to check multiple VAT numbers at a time but not sure if its possible either?
Thanks for looking through. I'm just starting out with VBA so I'm sure I'll be back here again and again!!!