ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to load /import the external worksheet into Excel? (https://www.excelbanter.com/excel-programming/433038-how-load-import-external-worksheet-into-excel.html)

Eric

How to load /import the external worksheet into Excel?
 
Does anyone have any suggestions on how to load / import the external
worksheet into Excel?

I would like to load / import the following link "HSI" sheet into Excel,
http://www.hsi.com.hk/HSI-Net/static...a1_21Aug09.xls

I am not open it, but load / import data within "HSI" sheet into Excel
through macro,
does anyone have any suggestions on how to code the macro to do it?
Thanks in advance for any suggestions
Eric


All times are GMT +1. The time now is 07:55 PM.

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