+ Reply to Thread
Results 1 to 4 of 4

VBA - Internet Explorer, fill in form and hit enter

  1. #1
    Registered User
    Join Date
    08-28-2015
    Location
    Melbourne, AUS
    MS-Off Ver
    2011
    Posts
    59

    VBA - Internet Explorer, fill in form and hit enter

    Hi,

    I'm trying to fill in a form online (intranet), and am using the method

    Please Login or Register  to view this content.
    It works fine replacing the value on screen, but it's not updating the selection.

    Maybe not the right choice of words, but it's like it's typing in the name but not pressing enter or tab to confirm the selection.


    Is there a way to press enter or tab in code? Or is there another way to confirm the selection?

    Many thanks.

  2. #2
    Valued Forum Contributor PFDave's Avatar
    Join Date
    05-17-2012
    Location
    Milton Keynes, England
    MS-Off Ver
    Excel 2013
    Posts
    1,067

    Re: VBA - Internet Explorer, fill in form and hit enter

    When you refer to it's not updating the selection do you mean it's not displaying it as a hyperlink? Or do you mean it's not actually updating the value in A1?

  3. #3
    Registered User
    Join Date
    08-28-2015
    Location
    Melbourne, AUS
    MS-Off Ver
    2011
    Posts
    59

    Re: VBA - Internet Explorer, fill in form and hit enter

    It was inputing the value, but not confirming? it.

    The value would default to Cairns (suburb), when a new suburb was entered you'd enter the value and hit enter to change the selection. In this case it would enter the suburb but not change the selection.

    Resolved now, the Sendkeys command worked after selecting the element

  4. #4
    Valued Forum Contributor PFDave's Avatar
    Join Date
    05-17-2012
    Location
    Milton Keynes, England
    MS-Off Ver
    Excel 2013
    Posts
    1,067

    Re: VBA - Internet Explorer, fill in form and hit enter

    Quote Originally Posted by mrshl9898 View Post
    It was inputing the value, but not confirming? it.

    The value would default to Cairns (suburb), when a new suburb was entered you'd enter the value and hit enter to change the selection. In this case it would enter the suburb but not change the selection.

    Resolved now, the Sendkeys command worked after selecting the element
    Glad you got it sorted

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA code in Excel doesn't recognize form from Internet Explorer
    By rodrigoo in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-26-2017, 10:11 AM
  2. macros for copy paste excel data on to Internet explorer form
    By Zuber Ahmed in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-24-2015, 08:09 AM
  3. [SOLVED] How to toggle focus between INTERNET explorer window and WINDOWS explorer window using VBA
    By tnuis in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-08-2013, 03:29 PM
  4. VB CODES to open internet explorer & fill form automaticlly
    By sheikhmisbah in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-23-2012, 03:55 PM
  5. Internet Explorer form automation from Excel
    By Julesdude in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-25-2010, 08:04 AM
  6. Using internet explorer through VBA
    By bodis in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-04-2010, 05:47 AM
  7. Using Excel to Complete Form in Internet Explorer
    By ShannonLarson in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-29-2007, 09:28 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1