Scrape website property search results linked pages into excel (PC or MAC)

[SGMacro]

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.

 

[sijpie]

Once you have the source code of the page you can do a search in each line of hthe text file for your href="/Prperty-to-rent"

loop through each line storing the line in a string variable sLine
then

dim sLine as string
...
'get each line into sLine
...
dim lL as long
lL = Instr(sLine,"href=""/property-to-rent/") 'lL will be 0 if not found
if lL then
   sLink=Mid(sLine,lL+6,Instr(lL,sline,"""")-(lL+6))
   ' sLink should now contain /property-to-rent/property-52985195.html
   ... do whatever
end if

 

[SGMacro]

Thanks sijpie.