Consulting

Results 1 to 2 of 2

Thread: Filling field in Internet Explorer from excel

  1. #1

    Unhappy Filling field in Internet Explorer from excel

    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...

  2. #2
    VBAX Master paulked's Avatar
    Joined
    Apr 2006
    Posts
    1,007
    Location
    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!
    Semper in excretia sumus; solum profundum variat.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •