ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Connect cell to a numbet on the Internet (https://www.excelbanter.com/excel-discussion-misc-queries/160284-connect-cell-numbet-internet.html)

Haris

Connect cell to a numbet on the Internet
 
Hello guys,

Somone told me is possible to connect a cell in excel to a number on the
internet, and thus the value of the cell to change according to the number on
the internet.

Can this be done? Because i've searched the web and i did not find anything.

Thank you all,
Haris.

Mike H

Connect cell to a numbet on the Internet
 
Hi,

You may mean importing data, if so try this:-

Select a cell and then
Data|Import external data|New Web query
A window pops up into which you could paste something like
http://www.x-rates.com/

Click Go and you will be sent to a site that gives exchange rates. Select a
table you want to import and then click import and your query will be
populated to your worksheet.

Rift click the query and click Data range properties to set up the refresh
times.

Mike

"Haris" wrote:

Hello guys,

Somone told me is possible to connect a cell in excel to a number on the
internet, and thus the value of the cell to change according to the number on
the internet.

Can this be done? Because i've searched the web and i did not find anything.

Thank you all,
Haris.



All times are GMT +1. The time now is 01:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com