How to load this online worksheet into Excel?

[Eric]

Does anyone have any suggestions on how to write a macro to load this online
worksheet into Excel?
http://www.hsi.com.hk/HSI-Net/stati...tin/ips/Index_Performance_Summary_21Aug09.xls
Thanks in advance for any suggestions
Eric

 

[p45cal]

this worked:Sub blah()
Workbooks.Ope
("http://www.hsi.com.hk/HSI-Net/stati...tin/ips/Index_Performance_Summary_20Aug09.xls")
End Su