Hi Eric

You can try this
http://www.rondebruin.nl/copy7.htm
If the range is to big it will not work



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Eric" wrote in message ...
Refer to the post in General excel

Does anyone have any suggestions on how to load data from excel file through
Web - Internet without download and save the excel file into my desktop?
For example
http://www.info.gov.hk/hkma/eng/stat...ch/T060202.xls
I would like to load all data from sheet "T6.3.2(HIBOR)" in my open file,
if the link is html, then I get no problem for loading, but the file is in
excel format, I cannot load any data through the Web.
Does anyone have any suggestions on how to solve this loading problem?
Thank you for any suggestions
Eric