Does anyone have any suggestions on how to import web link into Excel and
avoid frame on web page?
When I browse following link, it look fine on IE, but when I insert this
link into excel, it shows nothing, because of frame within HTML.
http://www.hkab.org.hk/DisplayIntere...&month=2&day=3

Does anyone have any suggestions on how to solve it within Excel?
Thanks in advance for any suggestions
Eric

When I right click on the sheetimport to excel, I get. You can the record a
macro to refresh.

Rates as at 11.15 a.m. Hong Kong Time on 3/2/2010.
Maturity HKD Interest
Settlement Rate

Overnight 0.03
1 Week 0.04936
2 Weeks 0.05
1 Month 0.07
2 Months 0.1
3 Months 0.13
4 Months 0.16
5 Months 0.2
6 Months 0.24857
7 Months 0.29643
8 Months 0.34571
9 Months 0.38857
10 Months 0.43857
11 Months 0.48857
12 Months 0.53857


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Eric" wrote in message
...
Does anyone have any suggestions on how to import web link into Excel and
avoid frame on web page?
When I browse following link, it look fine on IE, but when I insert this
link into excel, it shows nothing, because of frame within HTML.
http://www.hkab.org.hk/DisplayIntere...&month=2&day=3

Does anyone have any suggestions on how to solve it within Excel?
Thanks in advance for any suggestions
Eric

Could you please give more detailed description on how to do it?
Thank you very much for any suggestions
Eric

"Don Guillett" wrote:

When I right click on the sheetimport to excel, I get. You can the record a
macro to refresh.

Rates as at 11.15 a.m. Hong Kong Time on 3/2/2010.
Maturity HKD Interest
Settlement Rate

Overnight 0.03
1 Week 0.04936
2 Weeks 0.05
1 Month 0.07
2 Months 0.1
3 Months 0.13
4 Months 0.16
5 Months 0.2
6 Months 0.24857
7 Months 0.29643
8 Months 0.34571
9 Months 0.38857
10 Months 0.43857
11 Months 0.48857
12 Months 0.53857


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Eric" wrote in message
...
Does anyone have any suggestions on how to import web link into Excel and
avoid frame on web page?
When I browse following link, it look fine on IE, but when I insert this
link into excel, it shows nothing, because of frame within HTML.
http://www.hkab.org.hk/DisplayIntere...&month=2&day=3

Does anyone have any suggestions on how to solve it within Excel?
Thanks in advance for any suggestions
Eric

.

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Eric" wrote in message
...
Could you please give more detailed description on how to do it?
Thank you very much for any suggestions
Eric

"Don Guillett" wrote:

When I right click on the sheetimport to excel, I get. You can the
record a
macro to refresh.

Rates as at 11.15 a.m. Hong Kong Time on 3/2/2010.
Maturity HKD Interest
Settlement Rate

Overnight 0.03
1 Week 0.04936
2 Weeks 0.05
1 Month 0.07
2 Months 0.1
3 Months 0.13
4 Months 0.16
5 Months 0.2
6 Months 0.24857
7 Months 0.29643
8 Months 0.34571
9 Months 0.38857
10 Months 0.43857
11 Months 0.48857
12 Months 0.53857


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Eric" wrote in message
...
Does anyone have any suggestions on how to import web link into Excel
and
avoid frame on web page?
When I browse following link, it look fine on IE, but when I insert
this
link into excel, it shows nothing, because of frame within HTML.
http://www.hkab.org.hk/DisplayIntere...&month=2&day=3

Does anyone have any suggestions on how to solve it within Excel?
Thanks in advance for any suggestions
Eric

.