ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to load this online worksheet into Excel? (https://www.excelbanter.com/excel-programming/432751-how-load-online-worksheet-into-excel.html)

Eric

How to load this online worksheet into Excel?
 
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/static...ry_21Aug09.xls
Thanks in advance for any suggestions
Eric

p45cal[_74_]

How to load this online worksheet into Excel?
 

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



All times are GMT +1. The time now is 04:26 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com