Using VBA to search website and return results on Sheet

[jamesmev]

Hello. I am pretty still new at VBA and I am at a loss. I am working on a project where i want to search a site through excel using VBA. (example : Find Your Local Contact) I want to enter the zip code
and the results are returned on the excel sheet.

Any help would be greatly appreciated!!

 

[jamesmev]

I was able to achieve the search and the results appear in excel. However, the results move my columns over to the right and I'm looking just to obtain specific criteria from the search. Not all on that page.
Any ideas how to do this?

Sub URL_Get_ABN_Query()
strSearch = Range("G15")
With ActiveSheet.QueryTables.Add(Connection:="URL;https://xxxx
Destination:=Range("A1"))


.BackgroundQuery = True
.TablesOnlyFromHTML = False
.Refresh BackgroundQuery:=False
.SaveData = True
End With
End Sub