I need to fix an excel macro that downloads box scores

[mvpexchange]

I have a macro that calls up a separate workbook for each NBA team, checks if that team has played today and if it has it returns a box score for that team, parses it by individual player, states whether that team has won or lost (W or L), and puts a Y next to that date to notify the program to skip it next time.

You are supposed to be able to just open the file called "Master" and it runs through each team's worksheet "Hawks Stat Collator Auto" for example. Right now when you open master, it opens the "Hawks Stat Collator Auto" but nothing happens and the program stops running. No connection is made to the website to download the scores.

I am stuck right now and any help or insight would be appreciated. The master file and one of the team files are attached.

Master.xlsm Hawks Stat Collator Auto.xlsm

[Norie]

Do you get any error messages?

When I run the code it definitely seems to be doing something - IE opens various times but eventually it stops here in the GetOpenIEByTitle function.

Please Login or Register  to view this content.

With this error - Automation error The object invoked has disconnected from its clients.

Is this what's happening to you?

[mvpexchange]

right now no connection is being made, it is simply opening the hawks collator and then just stops. No spinning wheel or anything. I am going to try on my laptop to see if I can at least make a connection.

[mvpexchange]

I tried it on my laptop and it DID make a connection but just to the main url espn.com, it didn't go any further and then just ended.

[Norie]

Has this code worked in the past?

[mvpexchange]

yes since 2010. I don't know if it has stopped because of a change in their urls, or table structures or something else. When I copy and paste a box score into the collator and push collate it works correctly, so I know it has something to do with connecting to the website and finding the right page.

[Norie]

Well it's definitely possible that the site has changed structure.

Where do I find the 'collator'?

[mvpexchange]

I attached two files in my first post. master.xlsm is the main file that i open. when that is opened it cycles through each team file "Hawks Stat Collator Auto.xlsm" for example. Then it checks that file to find if that team has played a game that day and if it has it should pull that specific box score. Then close that team file and open the next one.

[Norie]

So what is the 'collator' that works?

Is it the workbook 'Hawks Stat Collator Auto.xlsm'?

Have you tried stepping through the code to see what's happening?

[mvpexchange]

If you look at this file below and check the first tab called "box score" I have copied and pasted the box score there and if press collate it will work correctly. The problem lies in obtaining that box score and I believe the issue is a change in urls at espn.com. I had been using the date and team codes to get to the correct url.

Hawks Stat Collator Auto.xlsm

[Norie]

If the URLS etc have changed then I think the code might need a major overhaul.

[Norie]

This is one of the URLs generated the code, in fact it's the first one.

http://espn.go.com/nba/boxscore?gameId=321020001

When I try that in IE it doesn't seem to be recognised and IE goes to the NBA index.