Does anyone have any suggestions on loading the web link into Excel?
Following codes is working before, recently when I run the macro, it can
open the wb.Sheets("Industry Indexes"), but fails to copy into Sheets("Temp")
and close it.
Does anyone have any suggestions on what is going wrong?
Thanks in advance for any suggestions
Eric

Dim wb As Excel.Workbook
Set wb = Workbooks.Open("http://main.hsi.com.hk/hsicom/table/dyforma1.xls")
wb.Sheets("Industry Indexes").UsedRange.Copy
ThisWorkbook.Sheets("Temp").Range("A1")
wb.Close False