+ Reply to Thread
Results 1 to 3 of 3

Excel - Logging on to a website

  1. #1
    Registered User
    Join Date
    10-02-2007
    Posts
    13

    Excel - Logging on to a website

    Good Morning

    I am trying to automatically log on to a website site using a login and password.

    I have created a sample code to log on to the website and enter the relevant username and password but I can't get the submit button to work.

    Any ideas on where I am going wrong

    Sub GetTable()

    Dim ieApp As InternetExplorer
    Dim ieDoc As Object

    Set ieApp = New InternetExplorer

    ieApp.Visible = True

    ieApp.Navigate "http://fantasyfootball.dailymail.co.uk/log-in"
    Do While ieApp.Busy: DoEvents: Loop
    Do Until ieApp.ReadyState = READYSTATE_COMPLETE: DoEvents: Loop

    Set ieDoc = ieApp.Document

    With ieDoc.forms(0)
    .Email.Value = "n.collins@tauntondeane.gov.uk"
    .pass.Value = "arsenal"
    .ieDoc.submit
    End With
    End Sub

  2. #2
    Forum Contributor
    Join Date
    07-13-2007
    Posts
    151

    Re: Excel - Logging on to a website

    Try:
    Please Login or Register  to view this content.
    instead of
    Please Login or Register  to view this content.
    within your With block

    If that doesn't work try:

    Please Login or Register  to view this content.
    outside your With block
    Last edited by ShredDude; 06-15-2011 at 12:51 PM.

  3. #3
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Excel - Logging on to a website

    Hi jsomer2000, please use code tags around your code as per forum rule # 3 located here
    If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.

    ---Keep on Coding in the Free World---

+ 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