sam10187 Posted December 5, 2007 Share Posted December 5, 2007 Is there any way to get Excel to look up my RuneScape Highscores, including the exp? I've been trying to make a goal calculator on Excel, but I don't know any way to get Excel to look-up my Highscores. Obviously I could enter the exp manually, but if there's an easier way, I'd definitely prefer it. It's probably worth adding that I have no coding experience. Thanks in advance, Sam There are 10 types of people in the world - those that know binary and those that have a social life Link to comment Share on other sites More sharing options...
kelerps Posted December 5, 2007 Share Posted December 5, 2007 Go to data > import external data > new web query A window should popup, paste this address in http://hiscore.runescape.com/index_lite.ws?player= This should lead you to a text only page with a bunch of number separated by commas. Click the yellow and black arrow on the top left of the browser window and then click import. Your should now be in excel with the import data dialog box open. Click the properties button at the bottom of the dialog box. Here you can change your refresh option to your choice. Press ok. Then select the radio box that says put data in new worksheet. This will allow it to be out of the way for when you create your document. The data should be in the format rank,level,experience and if there is no data there will be a -1. It should be in the same order as the usual high scores. Select the data range and rename it hiscores so you just refer to it as a name. Now you will need to format your data to easily be used by other functions. If you go to insert function there will be lookup and reference formulas witch you theoretically will be able to use for that. If you cannot accomplish this then the VBA editor(alt +F 11) could be used. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now