+ Reply to Thread
Results 1 to 1 of 1

Automate website login where the website only allows manual input of username/PW

  1. #1
    Registered User
    Join Date
    02-25-2018
    Location
    Sweden
    MS-Off Ver
    2016
    Posts
    1

    Question Automate website login where the website only allows manual input of username/PW

    Hello,

    I'm writing a program where one of the steps is:
    Open internet Explorer and navigate to a website > Enter the username and password and press the button "Login".
    Now this is working just fine up to the point where the Login button gets pressed.

    Even though both the username and password fields are filled properly by my script, the website gives an error message when the Login button is pressed; saying "Username field can't be blank".
    If I manually type the username and password at this point it works, which makes me think that this website doesn't allow automated logins somehow?

    I wish I could give you the link for this website so you can observe the source code, but that's unfortunately not possible since the site can only be accessed through my workplace's network.

    I have played around with different things such as trying to type the username and password using SendKeys without success, all though I would rather avoid using SendKeys.
    I also tried letting the script fill the username and password and then use SendKeys to enter 1 letter and then remove it again but I didn't get that to work and it would also feel very unreliable.

    Any suggestions are greatly appreciated.


    **Edit**
    There is one way I have made this work; after the script enter the username it sets focus on the username field and then the same process with the password.
    However.. This doesn't work if the script actually clicks the Login button, I have to use SendKeys "{ENTER}" and I want to avoid that.
    Last edited by whiterabbit; 02-25-2018 at 12:19 PM.

+ 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. automate website login using VBA
    By MarkFltc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-28-2017, 01:58 AM
  2. Website login popup comes up blank in VBA "edit web query" - webpage login problem
    By GaryTheGolfer in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-16-2016, 05:08 PM
  3. VBA to login to a website
    By chrishtina in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-05-2015, 05:55 PM
  4. Website login
    By stangz71 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-28-2015, 08:14 PM
  5. [SOLVED] VBA to open website and Login using username and password????
    By SLANE in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-02-2014, 08:24 AM
  6. website login through vba
    By abousetta in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-04-2012, 09:32 PM
  7. Automate Website Login
    By Ada01 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-10-2009, 01:04 PM

Tags for this Thread

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