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