Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / January 2008

Tip: Looking for answers? Try searching our database.

Link a Cell to Information on a Web page

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bashar - 07 Jan 2007 12:17 GMT
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
Don Guillett - 07 Jan 2007 12:52 GMT
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??

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

> Hello,
>
[quoted text clipped - 12 lines]
>
> Bashar
Ndel40 - 20 Jan 2008 18:48 GMT
Worked great for me... Thanks!

> Try this.
> Bring up the web page>in the table you want select a symbol( SEK )>right
[quoted text clipped - 17 lines]
> >
> > Bashar
Don Guillett - 07 Jan 2007 16:41 GMT
Apparently NOT so urgent as stated since OP did not bother to come back.

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

> Hello,
>
[quoted text clipped - 12 lines]
>
> Bashar
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.