+ Reply to Thread
Results 1 to 8 of 8

VBA to Login to website

  1. #1
    Registered User
    Join Date
    05-23-2013
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    15

    VBA to Login to website

    Below is my code. When I test it with an arbitrary website, like google, it will fill in the text boxes, but when I try this site. I keep getting errors. Any thoughts?

    Please Login or Register  to view this content.
    Last edited by arlu1201; 05-24-2013 at 10:37 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    05-21-2009
    Location
    Great Britain
    MS-Off Ver
    Excel 2003
    Posts
    550

    Re: VBA to Login to website

    https://account.authorize.net/ uses frames, so you need to access the HTMLDocument within the frame in which the login input boxes exist. Search for HTMLDocument.Frames or IE.document.frames.
    Post responsibly. Search for excelforum.com

  3. #3
    Registered User
    Join Date
    05-23-2013
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: VBA to Login to website

    I'm still having trouble finding where to start. Any ideas were I can base my code off, maybe an example of this using frames?

  4. #4
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: VBA to Login to website

    IanHyman,

    Welcome to the forum.

    I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. In order to put code tags, either type [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] at the end of it, OR you can highlight your code and click the # icon at the top of your post window.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  5. #5
    Registered User
    Join Date
    05-23-2013
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: VBA to Login to website

    Am I getting any closer?

    Please Login or Register  to view this content.

  6. #6
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: VBA to Login to website

    Iane

    This is the source of the page you are navigating to.
    HTML Code: 
    There's no form in it, the form is in the frame called 'top'.

    You can access the frame via the frames collection of the document, which is what Chippy was sugggesting.
    If posting code please use code tags, see here.

  7. #7
    Registered User
    Join Date
    05-23-2013
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: VBA to Login to website

    Here is where I'm at
    Please Login or Register  to view this content.
    I'm getting a "Run Time Error '91'

    Any thoughts?

  8. #8
    Registered User
    Join Date
    05-23-2013
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: VBA to Login to website

    Sorry, but i got it.

    This is the line of the code i was messing up.

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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