ExcelBanter - Get Webpage data as text using VBA w/o Webquery

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Get Webpage data as text using VBA w/o Webquery (https://www.excelbanter.com/excel-programming/385320-get-webpage-data-text-using-vba-w-o-webquery.html)

Max

Get Webpage data as text using VBA w/o Webquery

Hi, I am having a list of URL i would like to retrive each URL content in
text formart in a active worksheet cell.

eg:
URL1: http://money.canoe.ca/News/AnalystRa...2/3737106.html
-------- from this URL Data should be paste in A1

http://money.canoe.ca/News/AnalystRatings/2007/03/12/
3737108.html -------- from this URL Data should be paste in A2

is it possible using without using webquery ? or by Macro ?

All times are GMT +1. The time now is 06:22 AM.