Jagulari
05-03-2014, 04:05 AM
Hi!
I have a problem, involving getting data from web into excel.
I want to take data from site euw.op.gg/summoner/userName=Calsot , where in the URL the last word, (for example Calsot) is the username of a player in a MOBA game. The data I'd like to get is his ranking. I know its written in the pages source code on row 336.
My goal is to make an excel worksheet, where i.e. into column A i would write the user name (Calsot, niQ, Airwax etc.) and into column B their rankings would appear.
I tried to make a VBA code to change the end of the URLs to the value in column A and make each unique URL look for source code row 336 and their ranking value.
As you could guess, I didnt succeed and I couldnt modyfy codes I found on internet to fullfill my needs.
Sadly I have no code to show you, because they didnt work and I continually deleted every failed effort I made. :P
I have a problem, involving getting data from web into excel.
I want to take data from site euw.op.gg/summoner/userName=Calsot , where in the URL the last word, (for example Calsot) is the username of a player in a MOBA game. The data I'd like to get is his ranking. I know its written in the pages source code on row 336.
My goal is to make an excel worksheet, where i.e. into column A i would write the user name (Calsot, niQ, Airwax etc.) and into column B their rankings would appear.
I tried to make a VBA code to change the end of the URLs to the value in column A and make each unique URL look for source code row 336 and their ranking value.
As you could guess, I didnt succeed and I couldnt modyfy codes I found on internet to fullfill my needs.
Sadly I have no code to show you, because they didnt work and I continually deleted every failed effort I made. :P