+ Reply to Thread
Results 1 to 10 of 10

VBA to login to a website

  1. #1
    Registered User
    Join Date
    03-05-2015
    Location
    Orange County , CA
    MS-Off Ver
    Microsoft Office 2013
    Posts
    6

    VBA to login to a website

    Can someone help to correct my vba. Error code 91 is appearing "object variable not set", but i am unsure of how to correct it. please help!!!


    Please Login or Register  to view this content.
    Last edited by chrishtina; 03-05-2015 at 04:20 PM.

  2. #2
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: VBA to login to a website

    Chris,
    Please wrap your code with code tags as per forum's rule. Please read forum's rule.

    Since the URL requires log-in details, I would not be able to help you further should you get another error.

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    03-05-2015
    Location
    Orange County , CA
    MS-Off Ver
    Microsoft Office 2013
    Posts
    6

    Re: VBA to login to a website

    Thanks for your help, but now I'm getting error code 424 for some reason it won't press the login button.

  4. #4
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: VBA to login to a website

    Chris,
    As I pointed out, it is difficult to see the source code if the address requires log-in details.
    This line is definitely wrong

    Please Login or Register  to view this content.
    You need to put in the actual URL

  5. #5
    Registered User
    Join Date
    03-05-2015
    Location
    Orange County , CA
    MS-Off Ver
    Microsoft Office 2013
    Posts
    6

    Re: VBA to login to a website

    Sorry, I've included the address


    Please Login or Register  to view this content.
    Thanks

  6. #6
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: VBA to login to a website

    I had similar code, but it might not work, but try it and see where do you get the error? Which line of the code?

    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    03-05-2015
    Location
    Orange County , CA
    MS-Off Ver
    Microsoft Office 2013
    Posts
    6

    Re: VBA to login to a website

    The error code doesn't appear until after the macro has finished running. Also, the submit button does not work. Could the error code have something to do with that?

  8. #8
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: VBA to login to a website

    The code is not supposed to do anything, but to open the site. How do you know the submit button does not work?
    Where is the rest of the code?

  9. #9
    Registered User
    Join Date
    03-05-2015
    Location
    Orange County , CA
    MS-Off Ver
    Microsoft Office 2013
    Posts
    6

    Re: VBA to login to a website

    Oh, I thought that the vba would direct me into the login afterwards. Do you have any similar codes to submit the login?

  10. #10
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: VBA to login to a website

    The simple answer is no. Your request requires 2 hurdles to jump on. First is to log-in to the site, and second is assuming that you are in, what information do you want to extract? I suspect you are new to web scrapping. I love to help you, but I am unable to test the code as it requires for me to log-in to the site.

+ 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. Website login
    By stangz71 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-28-2015, 08:14 PM
  2. [SOLVED] VBA To login to a website
    By Sun13Banjo in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-06-2015, 10:46 AM
  3. [SOLVED] VBA to Login to website
    By IanHyman in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-28-2013, 03:27 PM
  4. website login through vba
    By abousetta in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-04-2012, 09:32 PM
  5. Website login help
    By davemaddocks in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-19-2011, 10:59 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