Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: Send keys to IE page

  1. #1
    Board Regular
    Join Date
    Jul 2014
    Location
    Rio, BR
    Posts
    350
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Send keys to IE page

    Is there a way to fill down a form in a webpage opened in the IE within excel VBA?

    Thanks
    Using Excel/Word 2010.
    Backup your original file before doing any modification.

  2. #2
    Board Regular Ruddles's Avatar
    Join Date
    Aug 2010
    Location
    Glevum Castra, Britannia
    Posts
    5,744
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Send keys to IE page

    The way I normally approach this sort of thing is to get the login page up and View Source to find out what the names of the fields are that I'm trying to fill in. Here's one I did last month:-

    https://www.mrexcel.com/forum/excel-...lications.html
    R.
    ---
    On two occasions I have been asked, 'Pray, Mr Babbage, if you put into the machine wrong figures, will the right answers come out?'
    I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.

  3. #3
    Board Regular
    Join Date
    Jul 2014
    Location
    Rio, BR
    Posts
    350
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Send keys to IE page

    Thanks, but it's not for log in, just to enter raw data and values, I'm trying to do something like autohotkey and phraseexpress do.
    So, the macro will get cell values and send the keys to IE.
    Using Excel/Word 2010.
    Backup your original file before doing any modification.

  4. #4
    Board Regular Norie's Avatar
    Join Date
    Apr 2004
    Location
    Stirling
    Posts
    72,576
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Send keys to IE page

    The code in the link Riddles posted is entering data/values.
    If posting code please use code tags.

  5. #5
    Board Regular
    Join Date
    Jul 2014
    Location
    Rio, BR
    Posts
    350
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Send keys to IE page

    its a java aplication runing within IE
    so I neeed to enter values in the form using sendkey...
    Thanks
    Last edited by eduzs; Apr 21st, 2017 at 01:57 PM.
    Using Excel/Word 2010.
    Backup your original file before doing any modification.

  6. #6
    Board Regular Norie's Avatar
    Join Date
    Apr 2004
    Location
    Stirling
    Posts
    72,576
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Send keys to IE page

    Can you post the URL?
    If posting code please use code tags.

  7. #7
    Board Regular
    Join Date
    Jul 2014
    Location
    Rio, BR
    Posts
    350
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Send keys to IE page

    Unfortunately not, cause it's not in the web.
    Using Excel/Word 2010.
    Backup your original file before doing any modification.

  8. #8
    Board Regular Ruddles's Avatar
    Join Date
    Aug 2010
    Location
    Glevum Castra, Britannia
    Posts
    5,744
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Send keys to IE page

    If the HTML code for the form appears in the HTML that's sent to your browser, the fields you're trying to put data into may have names that you can use. Can you post the HTML for the form?
    R.
    ---
    On two occasions I have been asked, 'Pray, Mr Babbage, if you put into the machine wrong figures, will the right answers come out?'
    I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com