+ Reply to Thread
Results 1 to 7 of 7

Excel macro that can open up a website and input a user name and password.

  1. #1
    Forum Contributor
    Join Date
    04-30-2013
    Location
    arizona
    MS-Off Ver
    365
    Posts
    147

    Excel macro that can open up a website and input a user name and password.

    Hello,
    I am having trouble finding code that will work with this website.
    I found the following code but it keeps opening the website and giving me the following error message: "Object variable or With block variable not set"
    can any one help me? I would also perfer to use chrome instead of IE if possible.
    Thanks,

    Please Login or Register  to view this content.
    Last edited by glide2131; 05-09-2014 at 09:02 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    09-01-2013
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2010
    Posts
    324

    Re: Excel macro that can open up a website and input a user name and password.

    You're probably getting the error because the login form is in a different frame and not actually on the page. You would need to login through the source the login form is on which is not the main page.
    Last edited by playaller; 05-09-2014 at 08:45 PM.


    Shelton A.
    If Helpful, Add Reputaion!

  3. #3
    Valued Forum Contributor
    Join Date
    09-01-2013
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2010
    Posts
    324

    Re: Excel macro that can open up a website and input a user name and password.

    Uee this as the login url and it will work


    HTML Code: 
    Here is your updated code.

    Please Login or Register  to view this content.
    Last edited by playaller; 05-09-2014 at 09:11 PM.

  4. #4
    Valued Forum Contributor
    Join Date
    09-01-2013
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2010
    Posts
    324

    Re: Excel macro that can open up a website and input a user name and password.

    If you need a full login pge try this one:

    HTML Code: 

  5. #5
    Forum Contributor
    Join Date
    04-30-2013
    Location
    arizona
    MS-Off Ver
    365
    Posts
    147

    Re: Excel macro that can open up a website and input a user name and password.

    Changing the address worked it brings up the page with the username and password in the fields but it does not submit it. I have to click on the login button. Do you know how to fix that?

  6. #6
    Forum Contributor
    Join Date
    04-30-2013
    Location
    arizona
    MS-Off Ver
    365
    Posts
    147

    Re: Excel macro that can open up a website and input a user name and password.

    I figured it out. The button id had to be changed. Thanks for your help.

  7. #7
    Valued Forum Contributor
    Join Date
    09-01-2013
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2010
    Posts
    324

    Re: Excel macro that can open up a website and input a user name and password.

    Sorry I forgot I had to change that as well. Glad I could help.

+ 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. 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
  2. Open a website and input text in search box
    By gtg430i in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-30-2014, 06:20 PM
  3. Replies: 0
    Last Post: 10-02-2013, 01:47 AM
  4. Replies: 6
    Last Post: 02-09-2013, 03:06 AM
  5. Open (website) for Input?
    By Joey Lichtenstein in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-16-2006, 11:00 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