Microsoft Excel is a great utility which helps in various ways. One of the in built features of Excel is the data import from Web, Access, Text and from various other sources like SQL etc.
Now I am going explain how to use Data Import from Web feature to see cricket scores. I found of this when I was in internship so that I can watch cricket scores in EXCEL without opening web browser.
However you must note that this method may work only with few sites. For Example, it works with CRICBUZZ and may not work with CRICINFO
Here are the steps involved:-
1. Open Microsoft Excel
2. Go to Data Menu and in the "Get External Data" section, select "From Web" or short cut key is "ALT + A + F + W"
3. A new browser window will open and enter the URL of the website from which you need fetch the scores . I've selected South Africa Vs England Score board from the www,cricbuzz.com (South Africa vs England). Then Hit "Enter" or Click "Go"
Note:- Most often you will get "Script Error" window. If you get it, then Select "Yes" and proceed
4. Now you need to click the Right arrow button in the screen which allows you to select which part of the page needs to be imported. You can select arrow buttons one by one or select the entire page
After selecting the required arrows, click import.
5. Once you click Import button, excel will fetch the date and will ask you to select the cell to which the data should be imported. Select the cell of your choice. I have Selected $A$1
6. That's all, now the scores are fetched from the website and you can scroll down the excel sheet to look at the scores
7. To refresh the scores in Data Menu, Connections sections, click "Refresh All" or shortcut key is "ALT + A + R + A"
You can see that scores get automatically refreshed.
You can even have a macro to automate refreshing of scores
a. First Go to Excel Options (ALT + T + O), then Trust Center Tab, select Trust Center Settings
b. A new Trust Center settings windows will be opened. In Macro Settings Tab, Select "Enable All Macros" and click Ok. Now your macros are enabled
c. Once Macros are enabled, now its time to create a new macro. Go to View Menu, Macros and
select "Record Macro" or Shortcut key is "ALT + W + M + R". Give a name for the Macro for example "Refresh". Click Ok and your macro will start recording now
d. Now you need to record an action for the macro to work. i.e. you must record the "refresh all" action. So, once you click Ok in previous step (i.e. step "c" above ), Go to Data Menu and in Connections section, select "Refresh all". After this again go to View Menu and in Macro Section, select "Stop Recording"
Now your macro has recorded the refresh all action.
e. Now we need to embed this macro to a shape, so that we can click the shape whenever we want to refresh scores. Go to Insert menu and then insert a shape . for example, rectangle.
f. Now right Click on the Shape and select "Assign a macro". Select the "Refresh" macro and click Ok. Now if you hover your mouse on the rectangle, it will change as a button.
You can even give a name for the button. Right click the rectangle button and select "Edit Text". Add text you want. For example "Refresh"
That's all. Now whenever you click that button, the score will automatically refreshed!!!!!