download web content into excel
 

Hi,

could you please let me know how I could download the following lin
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
macro? please help. Thanks

--
owl52
-----------------------------------------------------------------------
owl527's Profile: http://www.excelforum.com/member.php...fo&userid=2091
View this thread: http://www.excelforum.com/showthread.php?threadid=48893

download web content into excel
 

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

download web content into excel
 

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.


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

download web content into excel
 

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

Regards,
Ro

--
Ron Coderr
-----------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...fo&userid=2141
View this thread: http://www.excelforum.com/showthread.php?threadid=48893