Link a Cell to Information on a Web page

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Try this.
Bring up the web page>in the table you want select a symbol( SEK )>right
click>select export to microsoft excel>then data>import external data>data
range properties>refresh every??
 
Apparently NOT so urgent as stated since OP did not bother to come back.
 
Worked great for me... Thanks!

Don Guillett said:
Try this.
Bring up the web page>in the table you want select a symbol( SEK )>right
click>select export to microsoft excel>then data>import external data>data
range properties>refresh every??
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hyperlink to specific page in a pdf 1
hyperlinking from an Excel cell to a bookmark in Word 1
Page headers linked to a cell 1
Excel on a web page 3
Hyperlinks to a Specific Page in Word doc.. 2
How to determine within a macro if a cell contains a hyperlink. 4
Hyperlink to specific page in a PDF file 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2

Back
Top