Hi all,

Forgive the simple question, but I'm a bit new to programming still.

I'm trying to open up a webpage and enter in an ID and password, copy all data, and paste into my sheet. This is the code I have so far, I'm not sure where to go from here!


Sub get_data()

Dim ie      As Object
Dim URL     As String
Dim i       As Integer
Dim itm     As Variant

Dim varT    As Variant

Set ie = CreateObject("InternetExplorer.Application")
URL = "http://games.espn.com/flb/leagueoffice?leagueId=55112&seasonId=2017"
ie.Navigate (URL)
ie.Visible = True
Do While ie.ReadyState <> 4 And ie.Busy
    DoEvents
Loop


End Sub