Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to load data from excel file through Internet? | Excel Discussion (Misc queries) | |||
internet connection via excel macro at timed intervels & save data to excel file. | Excel Worksheet Functions | |||
Damage to .xls file upon data load | Excel Discussion (Misc queries) | |||
EXCEL FILE IN INTERNET | Excel Discussion (Misc queries) | |||
Dowloading internet data to worksheet form a ".ccv" file | Excel Worksheet Functions |