+ Reply to Thread
Results 1 to 4 of 4

vba to enter username and password on a website

  1. #1
    Registered User
    Join Date
    01-17-2017
    Location
    NEW JERSEY
    MS-Off Ver
    10.0
    Posts
    28

    vba to enter username and password on a website

    Hi,

    I have had success logging into websites using VBA but i am hitting a brick wall with the website I am working on now. I cant get it to enter the user ID and Password. Website is https://medi.hfs.illinois.gov/TruePa...oamingEPF.html

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,957

    Re: vba to enter username and password on a website

    It seems I've been able to get one space further than you. F12 is your friend in IE and also look at the source to get the element names you need.

    Please Login or Register  to view this content.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Registered User
    Join Date
    01-17-2017
    Location
    NEW JERSEY
    MS-Off Ver
    10.0
    Posts
    28

    Re: vba to enter username and password on a website

    Thanks for the response. I tried all this already but nothing is working. Also, i cant use getelementbyID because there are no ID's in the source code. Did you follow the URL and look at the source code?

  4. #4
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,957

    Re: vba to enter username and password on a website

    The page uses a java script applet that I am not familiar with. I suggest you research EntrustTruePass to see if it reveals anything else.

+ 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. Have VBA enter password on website
    By Malkavian in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-13-2016, 01:36 PM
  2. Macro to Open Website with Username and Password
    By slindfors in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-19-2015, 07:37 AM
  3. [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
  4. Macro that can open website and enter in username and password
    By glide2131 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-08-2014, 08:49 PM
  5. [SOLVED] username / password problem when getting data from website
    By JasperD in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2013, 01:51 AM
  6. [SOLVED] Username and Password Form - Show Username in Sheet
    By ryan180 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-24-2013, 07:06 PM
  7. access a website with username/password
    By redrav26 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 11-16-2009, 05:35 PM

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