Editing Macros to Control Web Scraping

[1234554321]

I have attached a file. I want to create(edit) a macros that allows me to to data>from web and use the site http://www.joelefkowitz.com/batter_card.php?pid= but then take the numbers in column B and add them at the end of that web site. For example, I would want it to go to http://www.joelefkowitz.com/batter_card.php?pid=453056 for player 1 and then do the same for the next 8 players. This is the code from a recorded macros if it helps. All I did was go to the site I want to for player 1 in webquery.

Please Login or Register  to view this content.

[teylyn]

Please wrap your code in code tags like this:

[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code]

I'll do it for you this time, because you're new to the forum, but please remember it from now on.

[1234554321]

I think I'm getting closer but a new issue has arised...
I changed the webquery part of the code and I THINK it's supposed to work that way but it isn't retrieving all of the information. It's only getting parts of the table I originally selected.

Please Login or Register  to view this content.

[1234554321]

bump. Please help