download web content into excel

[owl527]

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.

[Ron Coderre]

Try this:

Data>Import External Data>New 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
>
>

[owl527]

Hi,
this does not work as I am using a different version of Excel. It is excel 97.
is there another method I could use to do this?

pls help. Thanks.

[Ron Coderre]

Evidently, it's not quite so easy in Excel 97. This website explains how:
http://support.microsoft.com/kb/157482/en-us

Regards,
Ron