How to load an excel file through web link?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Eric - 19 Mar 2008 14:27 GMT

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 to this Message

Tim Williams - 20 Mar 2008 05:45 GMT

Just use

dim wb as Excel.WorkBook
set wb = Workbooks.Open("http://main.hsi.com.hk/hsicom/table/dyforma1.xls")

Tim

> Refering to the post in Excel Worksheet Function
>
[quoted text clipped - 6 lines]
> Thank you very much for any suggestions
> Eric

Reply to this Message

Eric - 20 Mar 2008 06:08 GMT

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

> Just use
>
[quoted text clipped - 13 lines]
> > Thank you very much for any suggestions
> > Eric

Reply to this Message

Tim Williams - 21 Mar 2008 02:57 GMT

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

> Thank you for your reply
> Could you please give more description on how to apply?
[quoted text clipped - 19 lines]
>> > Thank you very much for any suggestions
>> > Eric

Reply to this Message