| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to load a worksheet from Internet into a worksheet?
Does anyone have any suggestions on how to load the worksheet from Internet
into a worksheet? For example, I would like to load http://main.hsi.com.hk/hsicom/table/DyFormA1.xls for HSI sheet into my active worksheet? Thanks in advance for any suggestions Eric |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to load a worksheet from Internet into a worksheet?
Save the file from the Internet. Open the file, then use "Move or Copy
Sheet" if you want to copy a sheet from there to your own workbook. [Be careful with your terminology, and remember the difference between a worksheet and a workbook. If you actually want to put the data into an existing workSHEET, use copy and Paste.] -- David Biddulph "Eric" wrote in message ... Does anyone have any suggestions on how to load the worksheet from Internet into a worksheet? For example, I would like to load http://main.hsi.com.hk/hsicom/table/DyFormA1.xls for HSI sheet into my active worksheet? Thanks in advance for any suggestions Eric |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to load a worksheet from Internet into a worksheet?
Hi,
Try View|Toolbars - Web and paste the address into the adress bar. Mike "Eric" wrote: Does anyone have any suggestions on how to load the worksheet from Internet into a worksheet? For example, I would like to load http://main.hsi.com.hk/hsicom/table/DyFormA1.xls for HSI sheet into my active worksheet? Thanks in advance for any suggestions Eric |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to load a worksheet from Internet into a worksheet?
Thank everyone for suggestions
I would like to run a macro to load http://main.hsi.com.hk/hsicom/table/DyFormA1.xls into my worksheet, so everytime, I open this worksheet and run the macro, it will update the worksheet automatically. Does anyone have any suggestions? Thank everyone very much for any suggestions Eric "Mike H" wrote: Hi, Try View|Toolbars - Web and paste the address into the adress bar. Mike "Eric" wrote: Does anyone have any suggestions on how to load the worksheet from Internet into a worksheet? For example, I would like to load http://main.hsi.com.hk/hsicom/table/DyFormA1.xls for HSI sheet into my active worksheet? Thanks in advance for any suggestions Eric |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to load the web links into worksheet? | Excel Worksheet Functions | |||
| 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 | |||
| When I load a previous Excel workbook I lose my worksheet tabs. | Excel Worksheet Functions | |||
| Dowloading internet data to worksheet form a ".ccv" file | Excel Worksheet Functions | |||
Linear Mode
