VAT Number validation Tool
I have published an Excel tool that validates any EU VAT number and provides full business name and address if valid.
It only caters for EU countries.
The tool is free to download and use and requires internet connection. See links below.