+ Reply to Thread
Results 1 to 5 of 5

VBA to open website and Login using username and password????

  1. #1
    Registered User
    Join Date
    07-05-2014
    Location
    FL
    MS-Off Ver
    2010
    Posts
    3

    VBA to open website and Login using username and password????

    Good afternoon all,

    I want to start by saying this website has taken me incredible lengths with learning excel in a VERY short period of time!!! Thank you to everyone posting suggestions to others questions as I have learned a great deal from the support on this forum!!

    That being said I am finally stumped and have researched for days on getting this vba correct...

    I have tried to use many examples but keep running into minor glitches. I am trying to create a vba that opens a website and logs on using my username and password... I am getting stumped where the VBA code meets the HTML code... i think? Below is the code that i have so far but it opens the webpage but in the username box and password box it "undefined" and not what i have in the code... Any help is greatly appreciated!!!

    Below you will see the website, as i know u might need it to read the HTML labels for the username and password boxes (and submit button as i haven't gotten that far with the code yet. The code for the submit button now is from someone else's project...). Also, if i can use this code to open the website in google chrome instead of IE that would be awesome (but not absolutely necessary)
    Please Login or Register  to view this content.
    Last edited by Leith Ross; 09-21-2014 at 09:12 PM. Reason: Added Code Tags

  2. #2
    Registered User
    Join Date
    07-05-2014
    Location
    FL
    MS-Off Ver
    2010
    Posts
    3

    Re: VBA to open website and Login using username and password????

    ok so i added something i just found and it works for inputting the username and password but i am not stuck on the submit button...

    Thanks in advance! below are my changes
    Please Login or Register  to view this content.
    Last edited by Leith Ross; 09-21-2014 at 09:17 PM. Reason: Added Code Tags

  3. #3
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: VBA to open website and Login using username and password????

    Hello Slane,

    Your button is in fact not a button. It is an image with a hyperlink. You need to click the image to activate the "Login" hyperlink.
    I have made the needed changes to your code below...
    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  4. #4
    Registered User
    Join Date
    07-05-2014
    Location
    FL
    MS-Off Ver
    2010
    Posts
    3

    Re: VBA to open website and Login using username and password????

    Wow!! Perfect!! Can't thank you enough!

  5. #5
    Registered User
    Join Date
    09-28-2014
    Location
    Poland
    MS-Off Ver
    2013
    Posts
    2

    Re: VBA to open website and Login using username and password????

    Hi guys,

    According to enter the website using login and password Ive got an issue with following: https://online.noblesecurities.pl/Si...l?module=login
    The thing is I cant find in website script frame to input my login and what is more I am confused with inputting my password because the particular numbers I need to input in each frame are generating randomly.

    The point is I would like to enter this website and copy all content to excel.

    Please kindly see my code:
    Please Login or Register  to view this content.

    Can you please advise is it possible to input login and password by macro in this kind of website?

    regards,
    Simon
    Last edited by spectre8008; 10-02-2014 at 08:27 AM.

+ 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. Username and Password Login Dilemma
    By Kershree in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-08-2014, 07:59 AM
  2. 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
  3. Username/Password Login userform code
    By Nitefox in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-17-2014, 02:43 PM
  4. username and password login
    By dc123 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-17-2013, 08:38 AM
  5. Username and Password login in MS Excel 2010
    By beseda2004 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-03-2011, 03:45 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