Excel Import MLB Lineups....please help

[oilcountry99]

I'd like to import the lineups from this link into excel.

http://espn.go.com/fantasy/baseball/story/_/page/mlb_dailylineups/daily-lineups-fantasy-spin-every-game-mlb

When I do an excel import of the link it leaves out all the projected lineups. Is there a way to get this data into excel?

It seems as though the lineups are a separate link within the webpage.


Thanks in advance.

[Waterstpub87]

do you get a browser not updated error?

If espn won't work, https://rotogrinders.com/lineups/mlb?site=fanduel is another site that had lineups.

[oilcountry99]

No error, just doesn't bring the lineup data in, on matchups.

How accurate is rotogrinders? I'll look into it thanks.

[Waterstpub87]

no idea. Lineups come out too late for me.

[evo34]

Also,

http://www.baseballpress.com/lineups

[stevenash]

My go to lineup site.
West coast games are up 3 1/2 hours early tonight, but usually it's 3 hours early.

http://mlbstartingnine.com/home.jsp

[oilcountry99]

evo34
I use baseballpress to confirm lineups. I'm just trying to get an accurate lineup earlier in the day. I'm currently using baseballreference, then stumbled on the espn lineups which were much more accurate and I can get them sooner.

[jane2geo]

I'd like to import the lineups from this link into excel.

http://espn.go.com/fantasy/baseball/story/_/page/mlb_dailylineups/daily-lineups-fantasy-spin-every-game-mlb

When I do an excel import of the link it leaves out all the projected lineups. Is there a way to get this data into excel?

It seems as though the lineups are a separate link within the webpage.


Thanks in advance.

This VBA code will pull the Rockies lineup on today's page.
You then could duplicate or manipulate as you need.
If you PM your email I will send you a sample sheet.
===========
Private Sub Refreash_Lineup_Click()

'Option Explicit

Dim f As Worksheet

Set f = Sheets("lineupdata")
With f.Range("A2:Eb560").Clear
End With


Dim objWeb As QueryTable
Dim sWebTable As String
'You have to count down the tables on the URL listed in your query
'This example shows how to retrieve the 3rd table from the web page.
sWebTable = 3
'Sets the url to run the query and the destination in the excel file
'You can change both to suit your needs


Set objWeb = ActiveSheet.QueryTables.Add( _
Connection:="URL;http://espn.go.com/fantasy/baseball/story/_/page/mlb_dailylineups/daily-lineups-fantasy-baseball-tips-every-mlb-game", _
Destination:=Range("A2"))

With objWeb


.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True 'was true 20120627
.AdjustColumnWidth = True
.RefreshPeriod = 0
.WebSelectionType = xlSpecifiedTables
'.WebFormatting = xlWebFormattingAll
.WebTables = sWebTable
.WebPreFormattedTextToColumns = True
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = True
.WebDisableRedirections = False
.Refresh BackgroundQuery:=False ' was false


End With
Set objWeb = Nothing

End Sub

[oilcountry99]

This VBA code will pull the Rockies lineup on today's page.
You then could duplicate or manipulate as you need.
If you PM your email I will send you a sample sheet.
End Sub

PM sent