Thread
:
How to import web link and avoid frame?
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett[_2_]
external usenet poster
Posts: 1,522
How to import web link and avoid frame?
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
Reply With Quote
Don Guillett[_2_]
View Public Profile
Find all posts by Don Guillett[_2_]