Internet Explorer interation

[ChrisMattock]

I have an online form that I need to frequently populate from an excel spreadsheet, on the first page is a drop down box where I would normally select a category from. Why I click the category using the mouse it automatically advances me through to the next page, however when I use the macro below to do it, whilst the box shows the correct category, the page is not advanced. Can you help me?

Please Login or Register  to view this content.

As a bit of further information this is how the website deals with the box being changed (I don't understand it!):

Please Login or Register  to view this content.

[Chippy]

Try clicking the Select element or firing its onChange event:

Please Login or Register  to view this content.

You will need an ie.ReadyState wait loop after this.

[ChrisMattock]

Chippy - you're a star... the FireEvent line worked perfectly!

[ChrisMattock]

Thanks for helping with my problem, if you don't mind me asking I just have one more problem... on the next page I need to get the VB to click a link - no button unfortunately - the code just looks like this:

<a href='http://www.mysite.com/upload_file.php?pic_cat_id=322207'>
Upload Picture</a>

Unfortunately the URL changes depending on the entry number, so I need to click the link rather than going to a generic URL. Can you help? I don't know how to select and click that link?

[Chippy]

Get a reference to the link (HTMLAnchorElement). One way is by looping through IE.Document.links, looking for the link with innerText = "Upload Picture", or href containing part of the URL, e.g. "www.mysite.com/upload_file" (use Instr function). Once you have the reference, click it using:

theLink.Click

[ChrisMattock]

Thanks, but could you be more specfic as to how to do that? I don't seem to be able to get it to work. I tried the following - sorry, I'm really rusty on all this, I'm sure I'm completely wrong:

Please Login or Register  to view this content.

[Chippy]

IE.Document.links, not IE.Document.forms! Try this:

Please Login or Register  to view this content.