Web Automation using VBA

shloksurya · Sep 19th 2016

Hi,

I have a website

1] I need to enter the data into the website site fields through excel vba.
2] i am stuck at combo box, there are few combo box which should pick the data from excel cell
3] I am able to do the same with text boxes but i am not able figure out the combo box i have the code for combo box as below.

Code

Dim obj As Object




   For Each obj In IE.document.getElementsByTagName("select")(1).Options
    obj.Selected = True
    If obj.Selected = (UCase(obj.innerText) = UCase(ThisWorkbook.Sheets("RawData").range("E4" & 4).Value)) Then
    y = obj.Value
    Exit For
    Else
    y = y
    End If
    Next obj
    y = 0

Display More

But this does not work i have IE 11 version andexce2010

Please help me with this thanks in advance.

**S O** · Sep 19th 2016

Re: Web Automation using VBA

You know that the collection objects start from 0 by default, not 1? Are you absolutely sure that you've got the correct "select" element?

shloksurya · Sep 19th 2016

Re: Web Automation using VBA

i figured it out thanks for you help now i want to click on save button below is the code i want it to work in excel vba

HTML

<button id="upd" class="save" onMouseDown="submitBtnAndDisable('true','MERCH_MAINTAIN_DETAILS','upd')" name="upd" type="button">Save</button>

**S O** · Sep 19th 2016

Re: Web Automation using VBA

You're going to struggle there, it looks like the code that runs as a result of clicking that button is actually fired from a MouseDown event rather than the default "click" event.

It is possible to emulate such events in VBA but it requires very complex WinAPI calls that can cause more harm than help if you don't know what you're doing. VBA simply isn't the best tool to use for this kind of work, ideally you would use JavaScript instead.

Web Automation using VBA

Participate now!

Share

Users Viewing This Thread