I\u00a0will show you two ways to get such a Web query. The first\u00a0way will be easier because this instrument is integrated directly inside the browser Internet Explorer.<\/p>\n
1)\u00a0Web query through Internet Explorer<\/h2>\n
Open the browser\u00a0Microsoft Internet Explorer. You just need to find a Web page with a table, for our example we choose page of \u010cNB (link here\u00a0www.cnb.cz<\/a>) with an online list of foreign exchange rates. Explorer has a built-in option that can export selected table directly to Excel. Perhaps you can think of why this option has only the Explorer :-).<\/p>\n The picture shows a table with currencies. Just click\u00a0it in Explorer with right-click, the menu apperas and\u00a0at the bottom select Export to Microsoft Excel. A new Excel file is created and the table is copied into it. However, it is downloaded\u00a0with the option of updating directly from the site. The table in Excel is then possible to click\u00a0inside and on\u00a0a Data<\/em> tab > click Refresh<\/em> (or Refresh All). After that, the status bar displays information about running a web query and the table itself from the Internet resume with the new values. For this update you must be connected to the Internet.<\/p>\n The second way to connect to the Internet Web table, is\u00a0to use Excel directly without depending on your favorite browser. Click on the Data tab> Get External Data > From Web<\/em>. A\u00a0special browser window appears (looks old) in which the top line you can enter the address, as in the first described procedure. This time we choose the address of \u010cSOB bank (link is here\u00a0www.csob.cz<\/a>). The loaded page also contains a table with foreign currencies. Importing of online\u00a0tables through this process only works for tables that have a yellow arrow in the upper left corner in the browser window. Unfortunately, it does not work at all pages, it depends on how the page is created and coded. On that page but it works and you can try it without any problems. See the yellow arrow in the upper left corner of the table and after you tick the arrow it turns into a green “checkmark”. Then you simply complete the import by\u00a0Import<\/strong> button in the lower right corner of the window.<\/p>\n One more small windows opens in which we choose a target cell where the table shell be inserted. Alternatively, press in this window Properties, as shown below, and set the minute interval in which the table is updated automatically. Again, it will also work through the Data tab > Update<\/em> described in the first procedure.<\/p>\n![\"\"](\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2013\/12\/export_online_tabulka1-130x130.png\" "\\"\\"")
<\/a>\n\t\t\t<\/div>\n\t\t\t\t![\"\"](\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2013\/12\/export_online_tabulka2-130x130.png\" "\\"\\"")
<\/a>\n\t\t\t<\/div>\n\t\t\t\t![\"\"](\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2013\/12\/export_online_tabulka3-130x130.png\" "\\"\\"")
<\/a>\n\t\t\t<\/div>\n\t\t\t\t![\"\"](\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2013\/12\/export_online_tabulka4-130x90.png\" "\\"\\"")
<\/a>\n\t\t\t<\/div>\n\t\t\t\t2) Web query through\u00a0Excel<\/h2>\n
![\"\"](\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2013\/12\/webovy_dotaz1-130x130.png\" "\\"\\"")
<\/a>\n\t\t\t<\/div>\n\t\t\t\t![\"\"](\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2013\/12\/webovy_dotaz21-130x130.png\" "\\"\\"")
<\/a>\n\t\t\t<\/div>\n\t\t\t\t