Try this:

DataImport External DataNew Web Query
-Use your website:
http://www.hkex.com.hk/listedco/list...0051129026.HTM

-Select the table in that site with the conversion rate

Once you get the results in Excel, you can set up formulas that reference
the imported data.

Whenever you want to get the latest info, right click on the results range
and select Refresh Data

Does that help?

***********
Regards,
Ron


"owl527" wrote:


Hi,

could you please let me know how I could download the following link
into excel?
http://www.hkex.com.hk/listedco/list...0051129026.HTM
I want to be able to then sort the data in excel. Can I do this with a
macro? please help. Thanks.


--
owl527
------------------------------------------------------------------------
owl527's Profile: http://www.excelforum.com/member.php...o&userid=20916
View this thread: http://www.excelforum.com/showthread...hreadid=488930