build a code with will check UK VAT numbers with a website

[leebrook7]

Hi

I'm having a few issues and I'm hoping somebody can point me in the right direction. I just want to say I'm completely new at this so I will say sorry now

I'm trying to build a code with will check UK VAT numbers with a website. I have managed to get the code to enter the VAT number and click the button but I'm struggling with getting the response with a message saying Valid or Invalid VAT number

The code I am using is below

Please Login or Register  to view this content.

I think the Class Name I need is

<h1 class="govuk-panel__title">
Valid UK VAT number
</h1>

but it's showing a blank text box??

Any help will be much appreciated

[Marc L]

Hi, so why (1) : is there several elements with the same class name ?

If yes allocate the class name collection to a variable object then
in debug mode check within this variable which is the correct index of the expected element.

As internally the first element has the index zero but in the Locals window where you check the variable the first item is shown as #1 …

[mogul]

I wouldn't use Internet Explorer. It has been discontinued and most websites won't work with it. Look at using Selenium. How to setup

[leebrook7]

Hi

Thanks for your reply

I have changed it code to (0) but the box still comes back as empty

[Marc L]

So it's not the good element, see what contains the specific class name collection …

[leebrook7]

Just changed to Selenium

I can't seem to pull the info from a tag name called h4

Any idea how to read this string in a message box and also push it to a cell in Excel

Any help is much appreciated

[alansidman]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. Since you are new to this forum, I have added them for you.)

[alansidman]

Hi. Forum Rule 1 is very short. It states: "Title must briefly summarize your request."

A GOOD thread title is the sort of thing you would use as a search term on Google*. Your chosen title would produce a squillion useless hits. In future, please take a bit more time to think of a descriptive title that would be "Google-friendly". Many people search the forum answers looking for help and your very general title wouldn't help them at all.

Since you are a new user of this site, on this occasion, I have changed it for you.

However, if you continue to use weak titles, you can expect to have your thread BLOCKED until you change it yourself. If that happens, to edit the thread title, open the original post, click "Edit Post" (bottom right) to access the area where you can edit your title.

*Other search engines are available!!!