Hello
I am web querying data from a website to get data from quarterbacks. I am trying to create a loop in vba that will take a list of names and enter them into the URL so that I don't have to enter each name individually. I would like to compile the data into one long table of values. The following is the code I am using to get my data. It prompts for a name, I enter a name in this form "peyton-manning-1" and it returns 5 rows of data, each year and compiled career stats. I can compile a list of names and I just need a way for excel to step through the list and compile data in a table. I have little VBA experience and any suggestions would be great.
I am web querying data from a website to get data from quarterbacks. I am trying to create a loop in vba that will take a list of names and enter them into the URL so that I don't have to enter each name individually. I would like to compile the data into one long table of values. The following is the code I am using to get my data. It prompts for a name, I enter a name in this form "peyton-manning-1" and it returns 5 rows of data, each year and compiled career stats. I can compile a list of names and I just need a way for excel to step through the list and compile data in a table. I have little VBA experience and any suggestions would be great.
Code:
WEB
1
http://www.sports-reference.com/cfb/players/["name","EnterName"].html
Selection=passing
Formatting=None
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
DisableRedirections=False
