ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to insert web page content into excel worksheet? (https://www.excelbanter.com/excel-discussion-misc-queries/240031-how-insert-web-page-content-into-excel-worksheet.html)

Eric

How to insert web page content into excel worksheet?
 
Does anyone have any suggestions on how to insert web page content into excel
worksheet?
When I insert following link by importing external data within cell A1
http://www.hkex.com.hk/futures/futur.../dqe090817.htm

all data go into the cell A11, and I get no idea on how to split them, and
show them like the original web page layout.
Does anyone have any suggestions on how to do it?
Thanks in advance for any suggestions
Eric

joel

How to insert web page content into excel worksheet?
 
Your URL is wrong. extension should be either HK or COM, not both. You
can't have a URL in both Honk Kong and the USA.

"Eric" wrote:

Does anyone have any suggestions on how to insert web page content into excel
worksheet?
When I insert following link by importing external data within cell A1
http://www.hkex.com.hk/futures/futur.../dqe090817.htm

all data go into the cell A11, and I get no idea on how to split them, and
show them like the original web page layout.
Does anyone have any suggestions on how to do it?
Thanks in advance for any suggestions
Eric



All times are GMT +1. The time now is 01:34 AM.

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