Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to load an excel file through web link?
Refering to the post in Excel Worksheet Function
Does anyone have any suggestions on how to load following web link into Temp worksheet? http://main.hsi.com.hk/hsicom/table/dyforma1.xls I would like to load the "HSI" worksheet only from given web links Does anyone have any suggestions? Thank you very much for any suggestions Eric |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to load an excel file through web link?
Just use
dim wb as Excel.WorkBook set wb = Workbooks.Open("http://main.hsi.com.hk/hsicom/table/dyforma1.xls") Tim "Eric" wrote in message ... Refering to the post in Excel Worksheet Function Does anyone have any suggestions on how to load following web link into Temp worksheet? http://main.hsi.com.hk/hsicom/table/dyforma1.xls I would like to load the "HSI" worksheet only from given web links Does anyone have any suggestions? Thank you very much for any suggestions Eric |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to load an excel file through web link?
Thank you for your reply
Could you please give more description on how to apply? There are a few worksheet under this file, and I would like to load the "HSI" worksheet only into Temp worksheet. Your code does not include anything related to "HSI" worksheet. Could you please give me more suggestions? Thank you very much for any suggestions Eric "Tim Williams" wrote: Just use dim wb as Excel.WorkBook set wb = Workbooks.Open("http://main.hsi.com.hk/hsicom/table/dyforma1.xls") Tim "Eric" wrote in message ... Refering to the post in Excel Worksheet Function Does anyone have any suggestions on how to load following web link into Temp worksheet? http://main.hsi.com.hk/hsicom/table/dyforma1.xls I would like to load the "HSI" worksheet only from given web links Does anyone have any suggestions? Thank you very much for any suggestions Eric |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to load an excel file through web link?
dim wb as Excel.WorkBook
set wb = Workbooks.Open("http://main.hsi.com.hk/hsicom/table/dyforma1.xls") wb.sheets("HSI").usedrange.copy thisworkbook.sheets("temp").range("A1") wb.close false Tim "Eric" wrote in message ... Thank you for your reply Could you please give more description on how to apply? There are a few worksheet under this file, and I would like to load the "HSI" worksheet only into Temp worksheet. Your code does not include anything related to "HSI" worksheet. Could you please give me more suggestions? Thank you very much for any suggestions Eric "Tim Williams" wrote: Just use Tim "Eric" wrote in message ... Refering to the post in Excel Worksheet Function Does anyone have any suggestions on how to load following web link into Temp worksheet? http://main.hsi.com.hk/hsicom/table/dyforma1.xls I would like to load the "HSI" worksheet only from given web links Does anyone have any suggestions? Thank you very much for any suggestions Eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a way to unload the loaded XLL file in Excel? Hi all, I amdebugging XLL link library using Visual C++. Everytime I rebuild the XLL, Ihave to close the whole Excel program and relaunch the Excel program again,and then load in the newly gene | Excel Discussion (Misc queries) | |||
How to load data from excel file through Internet? | Excel Discussion (Misc queries) | |||
How to load data from excel file through Internet? | Excel Worksheet Functions | |||
Load List from External Excel file | Excel Programming | |||
Load DBF file into Excel on command line? | Excel Discussion (Misc queries) |