Extracting Specific Piece of Data From Web

Hey,

I've been trying to figure this out myself, but I haven't had too much luck. I'm not good with programming so that may be the problem!

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.

The exact URL for this is this...
http://www.google.com/search?hl=en&q=allinanchor:"keyword+goes+here"&btnG=Search

Could someone please help?

I would like to record a macro that would go from row to row and do each keyword that I have. I would also like to put a pause in between each run.

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.

I appreciate any help you guys can offer! Thanks!

Regards,
Adam Murray

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

Thanks, that's kind of what I was looking for, but, I'm looking to automate the following task...

I have an excel sheet with a list of keywords in the left column.

I want a macro that will go to each keyword and get the search results with 3 different parameters and input that data into the proper column.

It should automatically go through all the keywords until there are no more.

I also want a field where I can enter a number of seconds to wait in between each search.

The 3 search types are like this...

1) "keyword phrase"
2) allintitle:"keyword phrase"
3) allinanchor:"keyword phrase"

and this is for doing a Google search.

I'd like to have 3 different buttons for each search type and a button to run all 3 if I want to.

I have attached a spreadsheet of how I'd like it to look...

ExampleSpreadsheet.xlsx

ExampleSpreadsheet.xls

UPDATE: I hired someone off of rentacoder to do this for me... Thanks anyways guys!