Filling field in Internet Explorer from excel

[jpedrofernan]

Hello,

I'm new to VBA I think this is a really easy question but I have search here in the forum but with no sucess, so here it goes.

I have to fill a internet explorer with info from an excel.

Long story short I have everything working well, I'm sending key {tab} on the internet explorer to get to the correct field I know how to reference the correct cell in excel, but I just can't do the part where I fill in a field in the internet explorer.
My problem is, in this particular Internet Explorer Page I can't navigate the fields by id or class because they are dynamic, so i'm going trough a number of {tab} and them when I'm in the correct field I want to take a value from the excel and write it in the IE field, so I'm in the correct field in the IE I just need to write the value from the excel...

How can I do This, please help... :(

[paulked]

Hi and welcome to the forum.

I haven't done this for a long time but I think it's something like:



IE.Document.getElementById("xxxxxxx").Value = Range("A1")

Obviously changing the red bits!