Connecting two pieces of VBA (1) mainipulate a JAVA table and then (2) Webscrape

Hi Norie,

The second piece of code changes the drop down menu on the bbc website and then clicks 'update' do get the historical results of a given division.

That's what I meant by 'manipulating a Java table'. As the URL doesn't change per different result selected.

What I'm trying to accomplish is getting the webscrape after the drop down menu is changed by the second piece of code.

Thanks

As far as I can see, the data you're after is here: http://www.bbc.co.uk/sport/football/...tion-118996115 - you should be able to use a normal webquery to grab this

Hi Kyle123,

Thanks for your reply but it's the functionality I'm after more than the results themselves. But thank you for your post it is one way about going about getting the results.

Hi Norie - I'm looking for the functionality of changing a Java table by selecting what I want from a drop down menu then taking a webscrape?

Hi Kyle123 - How did you get that URL? http://www.bbc.co.uk/sport/football/...tion-118996115 thanks?

Hi Norie,

Yes the 2nd part of the code changes the table, and the 1st part of the code takes the webscrape but what I can't do, and what I am trying to do is change the table and then take the webscrape.

Hi Norie,

The second piece of code changes the results page specifically to just the championship results. It does this by selecting it in the drop down and then clicks 'update'. The 1st code only webscrapes the default URL (or default HTML table), I want the 1st piece of code to 'wait' until I've changed it to the championship results, before it webscrapes.

So I want to know how to integrate the two pieces of code, I thought it'd be possible to do this by changing the 1st piece of code to call on the other piece of code at the point when it calls upon the URL. I just don't know how to make that happen, hence my call to the boards....?

Kyle123 did suggest a slightly different way about getting the specific results, which I will probably resort too if the above can't be done, but I still need to know how he got to that webpage?

In theory I thought what I wanted to do was conceptually quite simple, the only thing in theory, that I want to do is call upon a macro piece of code instead of a variable. The variable currently being the cell that contains the BBC a URL. The macro being the second piece of code.