Problem with web inputs

[JerryGiese]

I am using VBA to open internet explorer, login, and enter a tracking number. The page where I enter the tracking number is:

http://www.hmm21.com/hmm/ebiz/track_trace/main_new.jsp

The problem happens when I try to enter the bill of lading number into the field. I tried this line of code:

ieobject.Document.All("numbers").Value = "Bill of lading goes here"

But then I just get an error as if that control doesn't exist. Can anyone help?

 

[Norie]

Jerry

This just isn't an Excel/VBA problem, it's probably more connected to how the website/page is designed and it's HTML source code.

In fact when I look at the HTML code I lost count of the number of times 'numbers' appeared.

 

[JerryGiese]

That is one of my problems. All of the controls are named "numbers".

 

[Fencliff]

Because the input fields don't have unique identifiers, you'll need to traverse the document tree to find the correct element.

In javascript, the first B/L field can be found like this:

document.getElementById('blfield1').getElementsByTagName('input')[0].value = 'Bill of Lading Goes Here'

Which takes the element by id 'blfield1' and find the first <INPUT> element. This would be pretty straigthforward to translate into VBA.