getting the right input box in a complex IE document

[Drio]

Hi

Just trying to fill the field GMC Reference Number on following site from Excel 2003 to IE8
http://webcache.gmc-uk.org/gmclrmp_enu/start.swe

and I'm stranded

Set objDoc = IE.document.body.Children.Item(0)
gives me the right frame according to a DOM browser addin in Firefox.
but I cannot seem to reach beyond that

The DOM structure is like this (each indented space is one level in the tree
#document
1st HTML
1st FRAMESET
1st FRAME
1st #document
1st HTML
1st FRAMESET
2nd FRAME
1st #document
1st HTML
1st BODY
2nd TABLE
1st TBODY
2nd TR
1st TD
1st FORM
2nd TABLE
1st TBODY
1st TR
1st TD
1st LI
LABEL
2nd TD
NOBR
INPUT


The INPUT has name="s_3_1_2_0" and id="gmcrefnumber"

Any clues would be welcome

Many thanks

[Chippy]

2nd frame within the 1st frame, therefore in one line:

IE.document.frames(0).document.frames(1).document.getElementById("gmcrefnumber").Value = "1234"

But rather than doing it in one statement, I suggest you set a reference to the very inner document shown above so that you can easily fill in all the form fields

[Drio]

Many Thanks Chippy, this does the trick

[Kyle123]

You would probably be better off posting the data directly to the server so you don't need to automate IE, automating ie is very slow.

You can then extract the following page data directly assuming this is what you are trying to do

Do you have a valid GMC ref no?

[Drio]

Kyle123, I get your point, but don't see how I can post direct to the server as it's not mine
If I could link the server I would just use T-SQL to pull it into the DB where i need it for verification
If you search for surname 'a*' (wh the quotes) it'll come up with a subset of some valid numbers of surnames starting with a after a while.

[Kyle123]

Hi Drio

Generally you can POST to any server, in this case it would be tricky however due to the sn it assigns to each request.

For a very simple example, have a look here, it's usually much faster than trying to automate Internet Explorer.

For more complex scenarios/more control you can use the MSXML library for which you can set the headers explicitly and parse the results