this worked:Sub blah()
Workbooks.Open
("http://www.hsi.com.hk/HSI-Net/static/revamp/contents/en/indexes/bulletin/ips/Index_Performance_Summary_20Aug09.xls")
End Sub
--
p45cal
*p45cal*
------------------------------------------------------------------------
p45cal's Profile:
http://www.thecodecage.com/forumz/member.php?userid=558
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=127757