How to load data from excel file through Internet?
 

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

How to load data from excel file through Internet?
 

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