Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link a Cell to Information on a Web page
Hello,
I'm trying to build a live model that includes a couple of cells representing currency rates limked to the internet so they can be updated live as the market moves. I've tried using the hyperlink option but the source web page has no bookmarks and the information on the web page is in HTML format not .xls. The site is www.fxcentre.com. Would appreciate some urgent assitance on how this can be done. Thanks Bashar |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link a Cell to Information on a Web page
Try this.
Bring up the web pagein the table you want select a symbol( SEK )right clickselect export to microsoft excelthen dataimport external datadata range propertiesrefresh every?? -- Don Guillett SalesAid Software "Bashar" wrote in message ... Hello, I'm trying to build a live model that includes a couple of cells representing currency rates limked to the internet so they can be updated live as the market moves. I've tried using the hyperlink option but the source web page has no bookmarks and the information on the web page is in HTML format not .xls. The site is www.fxcentre.com. Would appreciate some urgent assitance on how this can be done. Thanks Bashar |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link a Cell to Information on a Web page
Apparently NOT so urgent as stated since OP did not bother to come back.
-- Don Guillett SalesAid Software "Bashar" wrote in message ... Hello, I'm trying to build a live model that includes a couple of cells representing currency rates limked to the internet so they can be updated live as the market moves. I've tried using the hyperlink option but the source web page has no bookmarks and the information on the web page is in HTML format not .xls. The site is www.fxcentre.com. Would appreciate some urgent assitance on how this can be done. Thanks Bashar |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link a Cell to Information on a Web page
Worked great for me... Thanks!
"Don Guillett" wrote: Try this. Bring up the web pagein the table you want select a symbol( SEK )right clickselect export to microsoft excelthen dataimport external datadata range propertiesrefresh every?? -- Don Guillett SalesAid Software "Bashar" wrote in message ... Hello, I'm trying to build a live model that includes a couple of cells representing currency rates limked to the internet so they can be updated live as the market moves. I've tried using the hyperlink option but the source web page has no bookmarks and the information on the web page is in HTML format not .xls. The site is www.fxcentre.com. Would appreciate some urgent assitance on how this can be done. Thanks Bashar |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to display current page number in any cell of that page. | Excel Discussion (Misc queries) | |||
if i sort cell that has link to another page how to keep link | Excel Discussion (Misc queries) | |||
if i sort cell that has link to another page how to keep link | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
cell on one page equals cell on another page in excel? | Excel Worksheet Functions |