Extracting Specific Piece of Data From Web

Good morning AdamMurray

...and welcome to the forum!!

Originally Posted by AdamMurray

I'm trying to make a macro in Excel 2007 that will take a word from my spreadsheet, go to google, do a search in this format allinanchor:"keywordhere" and then pull only the number of search results from the results page and put that back into Excel.

My main concern right now is simply getting the data from the website into excel. I can most likely figure out the other stuff later.

Have a look at the attached spreadsheet. Type your searchterm into A1 on Sheet2 and click the button. This will perform a web query that will pull the results into Sheet2 and return the number of hits found. It's a bit rudimentary but seems to work fine so far.

HTH

DominicB