Excel VBA newbie looking to scrape property search results linked pages into excel.
I have read a few of the articles here and viewed a few videos online to help me understand how this is done and gave it a go using this property search.
The method I used was to save the webpage as a text file and then import into excel using data-import file feature which worked fine for the search results.
The problem is that the data I need is contained within each specific properties page and can only be accesses by clicking the link within each property advert.
I have right clicked the button and selected "inspect element" which shows the following link:
a href="/property-to-rent/property-52985195.html">£110 pw<span class="grey-text price-pipe price-pipe-small">|</span>
£477 pcm</a>
The bold text is consistent across all items property results, causing the relevant property webpage to open and I am wondering if this can be used to point some VB code to search all items on the webpage containing this, and pull the required data into excel
This is the first time I have looked into doing this so not sure where start and would welcome any help, thoughts, ideas, etc.
I have read a few of the articles here and viewed a few videos online to help me understand how this is done and gave it a go using this property search.
The method I used was to save the webpage as a text file and then import into excel using data-import file feature which worked fine for the search results.
The problem is that the data I need is contained within each specific properties page and can only be accesses by clicking the link within each property advert.
I have right clicked the button and selected "inspect element" which shows the following link:
a href="/property-to-rent/property-52985195.html">£110 pw<span class="grey-text price-pipe price-pipe-small">|</span>
£477 pcm</a>
The bold text is consistent across all items property results, causing the relevant property webpage to open and I am wondering if this can be used to point some VB code to search all items on the webpage containing this, and pull the required data into excel

This is the first time I have looked into doing this so not sure where start and would welcome any help, thoughts, ideas, etc.
Last edited: